Mapping Company Names based on a Mapping Table

[JochenF]

Hello everybody

I face the situation, that I have a external employee table with the service provider name spelled differently or given from it's subsiadary. 

The table looks like:

PersNo	Name	Service Provider
1	Meyer	Net IT
2	Summer	NetIT AG
3	Winter	Solutions AG
4	Flower	Solutions Service AG
5	Green	NetIT Education
6	Master	NetIT Services

I do have a mapping table like:

Service Provider	Service Provider Names
Net IT	Net IT
Net IT	NetIT AG
Net IT	NetIT Education
Net IT	NetIT Services
Solutions AG	Solutions AG
Solutions AG	Solutions Service AG

The wanted result table is:

PersNo	Name	Service Provider
1	Meyer	Net IT
2	Summer	Net IT
3	Winter	Net IT
4	Flower	Solutions AG
5	Green	Solutions AG
6	Master	Net IT

Hope some of you may help me to get the wanted result.

Thanks in advance and a very merry xmas time.

Jochen

[marcusblackhill · Accepted solution]

Hey @JochenF !

You can use a Find/Replace tool to do that like in the print below:

If you need, can look the example attached as well.

Hope that help!

[JochenF]

Thanks Marcus for that solution. I even didn't know this tool

Regards and a happy new yer, Jochen