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

[mer]

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

[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 :D

[mer · Accepted solution]

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.