How to create separate tabs in the same Excel sheet according to data in one column?

Hi All,

I want to create something in Alteryx that will allow me to take data from a specific column and have that data and the associated data in the subsequent rows mapped out into different excel tabs within the same workbook. How can I achieve this? Thanks in advance!

Workflow

Output

Help

Accepted answers

cadyb

@tinonsaha Have you tried doing this in the Output Tool by choosing the option at the bottom of the tool configuration "Take File/Table Name From Field" and choosing Change File/Table Name. Then select the column with the data that you want on separate tabs in the Excel workbook from the "Field Containing File Name of Part of File Name." This will generate one Excel workbook with your columns and data grouped onto separate tabs.

All comments

cadyb

tinonsaha

This did the trick, thank you so much!

Follow up question, how would I save each tab as a separate excel workbook?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335