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!
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.
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?
