Join us on August 11th as we explore Emotion Classification on Video with phData Learn more

Is it possible to extract multiple datasets from one workbook

Level 2
Is it possible to extract multiple datasets from one workbook

I have a sizeable excel document with around 10 sheets with different columns and different data.

Is there any way for me to use the same backend uploaded file to extract different datasets or do I have to upload the Excel workbook each time?

0 Kudos
2 Replies
Level 6

@pyousefi 

Screenshot-2020-03-10-at-15.54.14

I think there is a newish plug-in for this called Excel sheet importer.  It is listed as working with DSS V7.0

https://www.dataiku.com/product/plugins/excel-sheet-importer/

I've not used this personally.  However, it looks cool.  Will this do what you need?

I invite you to let us know how you get on with this.  If you run into problems let us know.

--Tom
Level 3

In addition to the plug-in @tgb417 suggested, the following approach is an option. Although it doesn't require a plug-in, it may be less flexible. 

Create a folder to upload the Excel file to (new Dataset, "Folder", store into filesystem folders). Upload the file to that folder.

Then from the vertical 3 dots menu for the file (hover over the file to see it), choose Create a Dataset. Click the Test button and then click on the Format / Preview tab. You can choose the Excel tab here. Create the dataset. Repeat this process for other Excel tabs.

Marlan