Combine multiple excel sheets to one excel sheet (Creating summary)

Question

Hello Alteryx Experts,

Stuck in creating summary.

I have around 40 excel files, in which there are two sheets -

1. Individual count

2. Summary

I want to display both in one excel sheet. Attaching sample files and expected output.

Is there any way to achieve this?

Thank you so much in advance.

Expected Output.xlsx

File3.xlsx

File2.xlsx

File1.xlsx

KGT · Accepted Answer

So, they are all the same format, and same sheet names?

Great to hear! Proceed as below then!

Directory Tool to get the fullpath's, then create a stream that appends |||Individual count to the end, and another parallel stream that appends |||Summary.

Then put each of them into their own Dynamic Input. You'll then have all the sheets in and you can do what you like.

If you have schema issues or sheet name issues, then you have inconsistent data, and same as above, but replace the dynamic Input with Batch Macro. You will find hundreds of questions on here dealing with Dynamic Input vs Batch Macro.