In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎10-16-2021 01:11 PM

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. 

Input Files.zip
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
Ar13f
10 - Fireball
‎10-16-2021 05:52 PM

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

Reply
0 Likes
Qiu
21 - Polaris
21 - Polaris
‎10-16-2021 06:11 PM

@sourabmehta2006 
We can use a macro for that.

1017-sourabmehta2006.PNG

1017-sourabmehta2006.yxzp
Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All