Alteryx Designer Discussions

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

Mapping Table Data Reconciliation

5 - Atom

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!

Alteryx
Alteryx

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

Labels