Fuzzy match but for columns headers

[Istwineres]

I was wondering if it is possible to use a better solution than multiple join to match the columns headers. I've got multiple files with different headers columns and different number of columns. Thanks!

[pedrodrfaria]

Hi @Istwineres 

The best solution I believe would be to Transpose the columns, apply the fuzzy matching, update the names, crosstab back to orientation it was before and move on with the workflow.

Pedro.

[cain_m]

The issue with this solution is that it changes the names of the columns, removing special characters (%,-,etc.) which are needed in my data. How can we do this without changing the column names?