Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Outputting multiple excel files using different cuts of raw data

Highlighted
7 - Meteor

Hi

 

Im currently getting to grips with Alteryx and have the following problem i am trying to solve so any help would be massively appreciated.

 

I have a data extract in an excel file that contains a bunch of information e.g. home addresses that you can cut multiple ways e.g. city, country, real estate type etc.

 

I've used alteryx to successfully cut this excel file into say 10 different files, one for each country using this method:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-data-into-multiple-files/td-p/1... 

 

What i want to do next is feed each of these 10 different cuts of raw data into another excel file that does a standardised set of calculations on the cuts of the raw data. e.g.

 

  • Analysis file_Greenland
  • Analysis file_Germany
  • Analysis file_Sweden

 

The formulas in each analysis file are all the same but the raw data used would be different based on the country it is filtered on, as would the file name. What would be the best way of doing this?

 

Any help would be greatly appreciated!

9 - Comet

Hi @jgagalang1 

 

Please see the attached zip file. I'm using a Directory Tool to grab a template file, using the Append and Formula tools to create a cmd script, and then the Run Command Tool to copy, rename, and save new versions of this template to the desired output folder.

Once these files are created, I'm using a Join and Formula Tool to update and create a PATH field that is used to split out my Raw Data into the different files.

Maskell_Rascal_0-1593535214638.png

 

Folder Setup:

Maskell_Rascal_1-1593535238785.png

 

Starter File:

Maskell_Rascal_2-1593535253960.png

 

Output Folder - Post Running Workflow:

Maskell_Rascal_3-1593535296107.png

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Thanks!

Phil

Highlighted
7 - Meteor

Phil, beautiful solution - super intuitive and easy to follow! Thanks so much for the help!

Labels