We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

How to Merge data of excel with multiple tabs into Single output file in Alteryx?

Bharad432
5 - Atom

How to Merge data of excel with multiple tabs into Single output file in Alteryx? I have multiple tabs and data is almost in similar format. I want combined data in One output file

1 REPLY 1
abacon
12 - Quasar

@Bharad432 Here is a macro that can do it. It uses batch macros to get the sheet names out of the file(s) provided, creates a dynamic input and pulls the data into one data stream that you can send to an output data tool.

 

Dynamic XLSX Input Tool 

 

Bacon