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

Combining Multiple individual excel file in One Workbook

sriniprad08
11 - Bolide

Hi Team,

Hope you are well. 

I have 10 individual excel file. I need to combine all of them into one workbook with different tabs.

 

For e.g 

Individual excel file - A, B, C,D

Output - One workbook - E ( with A, B, C ,D ) as individual sheets.

 

Please let me know,

 

thanks,

Sri

14 REPLIES 14
binuacs
20 - Arcturus

@sriniprad08 In that case you need another batch macro to get the sheet names first then another batch macro to combine all these sheets, one question all these excel sheets have the same number of columns and column names? 

binuacs
20 - Arcturus

@sriniprad08 Updated the workflow and included another macro to read the sheet names first, then the next macro will combine all the sheets, I assume that all of your sheets are having same schema (Same columns heading)

 

binuacs_0-1670319254227.png

 

sriniprad08
11 - Bolide

Hi @binuacs ,

 

Thank you so much for the help. unfortunately all the headers in the excel file are not same.

This will be little difficult. @gautiergodard  The solution proposed by Gautier is working.

 

Cheers,

Sri

gautiergodard
13 - Pulsar

Hello @sriniprad08 

Happy to hear the solution is working!

Could you please accept the post that provided the answer as a solution to this post?

This will help others in the future who have similar questions find answers more efficiently.

 

Thank You!

binuacs
20 - Arcturus

@sriniprad08 I updated the macro according to your requirement. Can you try to run the attached workflow and see you are getting the expected result or not?

 

binuacs_0-1670344950524.png

 

Labels