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.

WC2 - Output Main.xlsx

ntakeda

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 

dynamic_Fileoutput.yxzp