Combine many files (excel) into one

Question

Hi ,

Trying to combine many files (excel) into one but getting this message
Warning: Input Data (2): The file "S:\JOBS\DDD\XXX_REPORTING\xx_Combine\INPUT\SM_01072021.xlsx|||`Sheet1$`" has a different schema than the 1st file in the set and will be skipped.

Can any one help?

Thanks

ArtApa · Answer

Hi @HerveK - Here is one more article on the topic: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/ta-p/13370

JosephSerpis · Answer

Hi @HerveK have a look at this guide it will help you with your challenge.

FláviaB · Answer

Hi @HerveK. I am moving your post to our Designer Discussions board so it can have more visibility and the proper support. 😉