How do I view and select specific sheets from multiple Excel workbooks uploaded in DSS project?
Options
THEMAW
Registered Posts: 1 ✭✭✭✭
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.
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.
Tagged:
Answers
-
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
