Split 1 excel file with 4 tabs with different schema into multiple files by country

Hello. I have an excel file that contains 4 tabs. Within each tab there is data for each country (around 80 different countries). I need to split the data into separate files for each country (should have a total of around 80 files) with 4 tabs. Attached is a sample of my file. Any assistance will be greatly appreciated

sample file.xlsx

Macros

Common Use Cases

Help

Dynamic Processing

Accepted answers

mer

Step 1: Added 4 Input Data tool since I had 4 tabs to upload. Selected each tab within each Input Data tool. Step 2: Added formula tool with file name. The file name included the field titled "Territory" which contained the value for each country in my input file. I included the sheet name for each of the tabs within the formula. Step 3: Added 4 Output Data tool to each of the formulas. Within the output data tool, I selected the checkbox "Take file/table name from field". I then selected "Change Entire File Path" from the drop down. Lastly, I selected "File Name" as my field containing file name or part of file name. Refer to attached screenshots.

formula.png

output.png

All comments

mer

Disregard. I figured it out.

caltang

You can share your solution here for others to see and you can mark it as an accepted solution as well. This contributes to the community and to your future self referencing your own work

mer

formula.png

output.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703