community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Create Multiple Tabs From A Unique Identifier

Meteoroid

I want to ouptut multiple tabs baced off of a unique Id within the data set.  Column E is the unique identifier.  I want Alteryx to take the data and create 2 tabs based off of Column E (Calc Id.) and save it to one excel file.

 

 

 

Tabs.PNG

Alteryx Alumni (Retired)

In the Output Data tool, there is an option at the bottom to "Take File/TableName from Field".

Once you select a file name for the total Excel spreadsheet at the top, check that box, select "Change File/Table Name", and select the "Calc ID" field as the field to use.

Note: the original sheet name that is in the file name is irrelevant.

Labels