Replacing values in source file with values from map

[Stanislaw]

Hello everybody,

I'm a beginner and I would gladly use your help.

So I have 2 files: one is a source file and the other one is a map. I would like to replace values from source file with values from the map.

Unfortunately, I don't know how.

Source File:

Date	Tea	Coffee	Milk	Beer
2020M10	45	12	63	73
2020M11	34	12	60	72
2020M12	46	14	59	85

Map File:

Tea	CODE: 1
Coffee	CODE: 2
Milk	CODE: 3
Beer	CODE: 4

Expected output

Date	CODE: 1	CODE: 2	CODE: 3	CODE: 4
2020M10	45	12	63	73
2020M11	34	12	60	72
2020M12	46	14	59	85

Thank you in advance!

[Assaf_m · Accepted solution]

Check attached solution

[Stanislaw]

Whoa, it works, thank you!

I've been trying to solve the issue with the "Find Replace" tool.

Turns out, I should have been using "Dynamic Rename" instead.