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
@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.
Bacon