community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

40 multiple Excel files into 1 Excel file with 40 tabs.

Asteroid

Hi,

 

I have 40 multiple excel files, and I want to combine them into 1 excel file just with 40 tabs.  How do I do that?

 

Thanks!

Bolide

Hi @yzhang316, I would probably create a batch macro with the control parameter being a list of the excel file paths, a dynamic input, and then an output to the excel file with "create new sheet" selected. The control parameter would then overwrite the sheet with the name of the excel file from the control parameter. Here's a pic of what it would look like.

 

Help1.PNG

Labels