They all Alteryx one excel with multiple sheets output separately (one tab per excel file)

Question

Hi I have one master excel file with multiple tabs within the file. I want to output each tab individually as a separate file.

After each sheet is separated into different excel files, I want to group related specific sheets together. They all have different schemas. How would I start to do that?

hazu · Answer

Hi, my excel file is already one master file (one workbook with many tabs). I want to separate each tab to a separate workbook but keeping the original tab name.

Thanks for the link but it seems to input multiple workbooks into one file which is the opposite of what I want.

Tam · Answer

There is nothing like diving into the deep end.

Take a look @AlexKo  post:

The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten