How to Combine Multiple Spreadsheets and Get Output in Multiple Tabs in Output File in Alteryx

[@jenniphervigil4058]

Thank you! I finally found a tutorial on this subject, it seems like the only tutorials I find are always one tool but splitting on the categories. Great explanation!

[@ulkeshkosh6164]

Thanks for this! I used the same technique to export 13 summarize tools & 13 filter tools into one file 😎

[@StockSausage]

Nice man! Thanks for the solution!

[@sirishaalla5509]

Well explained, oved it

[@newjk08]

Thank you & thank you!

[@megalomaniac7972]

Hm I get an error that it's unable to open my consolidate file once the first part of the flow runs.

[@wumengxuan760]

same same how do you solve it？

[@megalomaniac7972]

@@wumengxuan760 I was able to resolve the issue, but it's been a few months and it's all a bit fuzzy. I want to say I got the solution from their community forums.

[@megalomaniac7972]

What if one of the Workbooks has more than one sheet? Will this still work?

[@atulchandorkar2961]

Sir, i have multiple Output files, i want a consolidated sheet with a different sheet name.. can you help?

[@technobi0911]

Will comeback on this. Thank you for your support!

[@ajaygautam3621]

sir, sorry to say but this is not an appropriate way to bring multiple files there is a concept of macro in alteryx I am saying it because if there are thousands of files then what would you do?

[@technobi0911]

Yes, you can do that using wild cards in configuration.