Replacing data from one file to another

[harkuro]

I am very new to Alteryx and I was given a problem to solve. After reviewing the data I was given I realized that one of the files (I will call this file 1) had data in a certain field that gave me a reference number to the state's county that I needed. The issue with this was all other states have their actual counties name in the "county_name" field but for this state I am given reference numbers that correspond with the actual county's name. For the state that I am looking at (Virginia) I am given a reference number that I can read and match with the counties on another file (file 2). How can I match the reference numbers from file 1 and find the county name using the reference number (on file 2) and replace the reference number with the actual county's name (on file 1)? Below is what I am dealing with. The file format is .yxdb

File 1:

File 2:

[DataNath]

For file 1, bring in a Text to Columns tool and set the delimiter to =, making sure the configuration is set to split to 2 columns.

Your second output column should just be these reference numbers. Therefore, you can just bring on a Join tool and set the join to be on the reference number field from each file. Within the join configuration you can also untick and/or rename fields to tidy up your output.

[Qiu · Accepted solution]

@harkuro 
We can also utilize the Find and Replace tool as below.