Replace Names from one dataset with names from another

Question

Hello,

I have 2 datasets and I am trying to Join them with Branch name, however the names on one data set is written differently from the other.

For example:

Dataset 1Dataset 2Kent RetailKentBrighton CHRBrightonBoltley CMBBoltley

I am not able to match the 2 data sets as the names are different. I want to change the names on dataset 1 to be the same as dataset 2. I can not manually change the names as there are over 100 branches. I tried using the 'Find Replace' tool but it did not work. Please could you guys help me solve this issue.

Kenda · Accepted Answer

Hi @yashaschowdary

There are a couple ways you could do this. The first that comes to mind would be to use the Append Fields tool to create a row for every combination of your two datasets. Then, just add a Filter tool to only keep the ones where data set 1 contains the test in data set 2. See the attached workflow. Hope this helps!