SOLVED
Mapping Table Data Reconciliation
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
cchow_
5 - Atom
‎05-29-2019
12:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Datasets
1 REPLY 1
Moderator
‎05-29-2019
12:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
