Merge same set of files present in different folder

[Spartan_4023]

Hi Community,

Seeking out help for a alteryx designer solution

i have 3 folders lets say F1, F2,F3

in each folder i have 3  excel files S1, S2,S3 which are different Schema and all these 3 excel files have only 1 sheet.

S1 file under F1, F2, F3 are identical and have same name

S2 file under F1, F2, F3 are identical and have same name

S3 file under F1,F2, F3 are identical and have same name

i want to merge them and produce 3 outputs lets say O1,O2,O3

where O1= S1(F1)+S1(F2)+S1(F3)

and same with O2, and O3

how to achieve that?

moreover if folder count is more than lets say 10 then how can i make the solution dynamic 

[griffinwelsh · Accepted solution]

This assumes all of your sources are in a single parent folder, but is dynamic for any number of files. Update your directory path to whatever parent folder you are using. Also note that you will need to filter out whatever you call your output files by adding a filter tool on the control parameter. Otherwise your outputs will be included as a group on all subsequent runs