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

Alteryx designer Discussions

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

Mapping columns from different excel files

Highlighted
Asteroid

Hi All,

 

I have a scenario wherein I should combine 4 different excel files (for different years) into one. Basically, It's a survey data. The problem I have is, the questions even though they are similar the naming convention is not consistent. Is there a way I can use alteryx and help the client?

 

Please help!

 

Thanks,

Amit Belagali

Alteryx Partner

As its only 4 files I would just simply have 4 inputs, rename in a select and union.  There is a wild card xlsx input which you can get from searching and installing the CREW macros, however the  time you do that you could have read in the 4 manually

Labels