Output several excel files

Question

Hi,

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

Imput (yxdb):

Expected output (excel):

...

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!

ArtApa · Answer

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.

binu_acs · Answer

@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

SampleExcelWorkflow_26_05.yxmd

DataNath · Answer

@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.

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:

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

Output multiple excel files.yxmd