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

THEMAW

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.

Clément_Stenac

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