I have a data set where I first filter by a column "Region". Then each region needs to be crosstab to get the data the way I want it and then exported to an excel file. I need a file for each region (10+ files at the end).
What I have:
Account # | Account Name | CoCode | Value | Region |
1000 | xxx | 1-france | $$ | France |
1200 | xxx | 1-France | $$ | France |
1300 | xxx | 2-France | $$ | France |
1400 | xxx | 6-France | $$ | France |
1200 | xxx | 3-Germany | $$ | Germany |
1300 | xxx | 3-Germany | $$ | Germany |
What I want:
I want my output file to look like this but have the workflow produce separate output files for all the different regions. Is there a way to build this in the workflow to complete this process without having to build duplicates of the process in the workflow over and over for all the regions I have?
Account # | Account Name | 1-France | 2-France | 6-France |
1000 | xxx | $ | $ | $ |
1200 | xxx | $ | $ | $ |
1300 | xxx | $ | $ | $ |
1400 | xxx | $ | $ | $ |
Thanks for the response! Are you able to share the marco and workflow in separate files? I can't open the package for some reason.