Convert column's data based on mapping file

[accman1983]

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.

[gautiergodard]

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!

[ChrisTX · Accepted solution]

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

[accman1983]

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!