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.

Output

Accepted answers

ChrisTX

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

All comments

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!

rename.yxmd

ChrisTX

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703