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

THEMAW
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.

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 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
Setup Info
    Tags
      Help me…