Hello!
I need to map the output of a column based on a simple excel sheet.
For example: Source data (excel file) has Column A "Names". I need to output that same column but instead replace it with the "ID code" from an excel file mapping file where it has Column A as "Names" and Column B is "ID Code". In my output it should be all "ID Codes" as mapped.
This is not the exact application but is the scenario I need. What I'm looking for is the tool to use and I can run from there (I hope), but I can't seem to find this capability other than "renaming" the header which is not what I'm doing.
Solved! Go to Solution.
Hello @accman1983
Yes! You can do this using the dynamic rename tool.
Simple example attached which you can replicate with your dataset and mapping table!
Use the Input Data tool to import your Excel file.
Use the Join tool to join your data stream to the Excel data, and output the Column B "ID Code" from the Excel data.
Chris
I chose the join solution as it mapped the data to the new names (actual data within cells) whereas the "rename" example renamed the column itself. Thank you!