Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Output several excel files

mauricio
8 - Asteroid

Hi,

 

I'm trying to output several excel files like this:

Imput (yxdb):

mauricio_0-1653592187669.png

 

Expected output (excel):

mauricio_1-1653592222362.png

 

mauricio_2-1653592247719.png

 

...

 

mauricio_3-1653592261767.png

 

 

I have tried the output tool but I couldn't figure out how to make it work without 35 filters and 35 output tools.

 

Any help would be much appreciated.

Best regards!

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

@mauricio you can do this by creating a custom filepath for each row, as below - you'll obviously just need to replace my drive with your own and where I have [excel] will be the field you're grabbing the name from.

 

DataNath_0-1653593018121.png

 

After this, in your Output Data tool, select 'Take File/Table Name From Field' and 'Change Entire File Path', using your newly made filepath from the formula tool:

 

DataNath_1-1653593083840.png

 


That should do the trick! Let me know if you have any issues. Example workflow attached!

 

binuacs
21 - Polaris

@mauricio as @DataNath mentioned you need to create a formual tool with the path where you need to save the output files. Attaching a sample workflow for your reference

 

binuacs_0-1653601077896.png

 

ArtApa
Alteryx
Alteryx

Hi @mauricio - You may watch the following training to understand the Output Data tool: https://community.alteryx.com/t5/Interactive-Lessons/Writing-Data/ta-p/74561#done

 

Note that that last section "Writing to Multiple Outputs" explains the topic.

Labels
Top Solution Authors