Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Combine Multiple excel file with multiple tabs into one single excel file.

sourabmehta2006
5 - Atom

I want to combine multiple excel file which has got multiple tabs like Sheet 1, Sheet 2 and Sheet 3. I want to combine only "sheet 1" from each excel file into one single excel file. I have uploaded the input files for your reference. Please help. 

2 REPLIES 2
Ar13f
10 - Fireball

Dear @sourabmehta2006 

 

Usually I use macros to work on problems like the one you are facing and where do I get the macro tools and learn from this community.

 

Solution 211017.png

 

please find the article where I learn this macro https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...

 

thanks to @JordanB for the article you shared....

Qiu
20 - Arcturus
20 - Arcturus

@sourabmehta2006 
We can use a macro for that.

1017-sourabmehta2006.PNG

Labels