Community Conundrums are live! Learn more

How do I view and select specific sheets from multiple Excel workbooks uploaded in DSS project?

Level 1
How do I view and select specific sheets from multiple Excel workbooks uploaded in DSS project?
I have loaded multiple Excel files, each with multiple sheets and need to select two sheets to work with from each file.

Currently I am only able to see a sample from the first sheets but those are not the sheets that I need to work with.
0 Kudos
1 Reply
Dataiker
Dataiker
Hi,

In the "Format/Preview" tab of the Excel dataset, you can select the sheets (after clicking at least a first time on preview).

Note that this mandates that the sheets have the same columns. If they don't, you'll need to create several datasets, each one targeting a specific sheet
0 Kudos
Labels (3)