Multi column worksheet extract to multiple files

[DaleN24]

Hello. 

I am new to Alteryx, and I have an excel file with one sheet, on that sheet are multiple columns each representing a different company, as well as three initial columns and row data that are applicable to all companies on the sheet.

Im trying to find a way to automatically extract each individual company column plus the 3 initial applicable columns, into separate worksheets for each company, with the column name extracted being made the file name.

Does anyone know if this is possible in alteryx apart from a column select tool approach which is way too manual.

[echuong1]

Yes, this can be achieved using Alteryx fairly easily.

Do you have a sample data file that you can upload? I can try to mock up a workflow and explain the exact steps needed.

[DaleN24]

Thank-you @echuong1 

I have uploaded an extract example worksheet.

[echuong1 · Accepted solution]

See attached - this will work regardless of how many companies you have.

You will need to update the formula tool with a path on your computer.

Hope this helps!

[DaleN24]

Thank-you @echuong1 . That looks like it will do the trick, iv done a quick test run and this looks to have worked.