We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

segragate records into Excelfiles

rama533
7 - Meteor

Hi..

 

Can we segregate records into Excel files based on Filename field without using Macro also?

2 REPLIES 2
danilang
19 - Altair
19 - Altair

Hi @rama533 

 

danilang_2-1678621120656.png

 

You can do this by simply building a filename field and then configuring the Output Data tool to Take the File/Table Name From Field section according to your needs 

danilang_0-1678620895322.png

 

A single Output Data tool generates 3 Excel files

danilang_1-1678621035565.png

Dan

 

rama533
7 - Meteor

Thank you so much..

Labels
Top Solution Authors