Generate multiple output from 2 fields?

[thua]

Hi everyone,

Could you please help on how to generate many output files from 2 fields? Or if there was another way to do it during workflow please?

Much appreciated!!!

Information: I have the file as attached, and I need to have 15 different output files that has unique product - region. 

-> The output option only allow to generate many output from 1 field, how do I do it with 2 fields (product and region)? 

I need the answer like product "spot" with region "Americas" only, and so on.

[ntakeda · Accepted solution]

1. Use the "Formula" tool

   • Create a new field combining product and region.
   • For example, create a new field called Output_filename with the value: product + "_" + region (e.g., Spot_Americas).

2. Use the "Output Data" tool with the "Take File/Table Name From Field" option

   • Set Output_filename as the file name field.

This will generate separate output files like Spot_Americas.xlsx, Spot_EMEA.xlsx, etc., based on the unique product-region combinations.

@thua 

[caltang · Accepted solution]

You can refer here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-data-into-multiple-file...

[thua]

Thank you for your help. I appreciate it. It solves the problem.

Just a quick ask, beside this, may there be another way to have the same output by using Union and Join? 

[thua]

I have read this first, I saw that one before writing my post, but I dont get it hahah. Thank you for forwarding it.