Multiple columns with different names

Question

I have various columns with different names. For example,"Acctng Date" and "Acctg Date" There are more columns with this issue, but I essentially would like to rename these columns and then combine the data. Is there an easy way to do this with there being so many columns that need to be renamed?

Yoshiro_Fujimori · Answer

If your tables has the same data structure

(i.e. the number of columns and the type of each column are the identical for all tables)

and the difference is only the column names,

the chances are that you may simply Union them with "Auto Config by Position".

https://help.alteryx.com/current/en/designer/tools/join/union-tool.html#idp344297

MadYX · Answer

* A couple of ideas come to mine. I don’t know how often your data is changing, but you could turn those into a list and export it and create a reference table and then reassign them based on that reference table and then if you got a new one that wasn’t in your reference, you could append it to the bottom of the list And add the Reference as needed. You would use a join tool to pull those new labels. Back in  
* another thought I had might be a fuzzy match of some sort 
* you could use find and replace to clean up the list