Mapping Table Data Reconciliation

Question

Hi,

I have 2 excel tables (A and B)  where the column headings are different. I have a mapping table that contains 2 columns which map excel A's column headings to excel B's corresponding column headings. What should I do to use the mapping table to change excel B's corresponding column to match?

Thanks!

LukeM · Accepted Answer

Hi @cchow_ ,

I think what you are looking for is the Dynamic Rename tool. This will allow you to rename the fields in Table B with the mapping table you are describing:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Dynamic-Rename/ta-p/32920

Let us know if this works.

Luke