Outputting multiple excel files using different cuts of raw data

[jgagalang1]

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!

[Maskell_Rascal · Accepted solution]

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.

Folder Setup:

Starter File:

Output Folder - Post Running Workflow:

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

Thanks!

Phil

[jgagalang1]

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

[ShravaniChanda]

is it possible for to look up the values from data table to template file because in your example country is used to split the files, and copy the each country's data to respective files, my requirement slight different, Let say I want to split the files based on company codes, each company codes will have few tax codes and the template has tax codes and cells next to that should updated tax amounts without any change in template.

Below is the snip of the template, green color are the only ones to be updated remaining headers and all the color format should not change. this is for company AAA

there are 30 plus other companies and all the codes for each company should follow and get formatted this way. any suggestion