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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Merge data from multiple excel files with different sheet and column names

Meteor

Hi All,

 

I have around 2K excel files in a folder which have data present on its first sheet, I need to combine (union/append) the data from all the 2k sheets. The names of the first sheet are different and the column names also are not the same for every file.

 

Any approach or workflow suggestion for this?

Labels