how to match city code and airport code

[merypals]

Hi all, I am working with two data sets. Is there a way to match the 3 letter airport code from File 2 to the 3 l3tter city code in File 1, having in mid airport codes differ from city codes.

File 1

MHM
BIG
ONT
IOW
IFA

File 2

airport code

MHM
BIG
JIO
IOW
IFA

Then I want to connect the city 3 letter code to the city name. 

[DataNath · Accepted solution]

Hey @merypals, you can just use the Join tool with the 'Join by Specific Fields' option set to [city code] = [airport code].

You'll see those records that don't match come out of the L (Left) and R (Right) anchors respectively. Can't upload screenshots at the moment but please find the workflow attached.

[Kottapally_Ramesh · Accepted solution]

Use join tool and see the J anchor for the output. 

Attached is the sample workflow.

[merypals]

Hey, I started with the Join tool and the two data sets connected. But the results are not accurate. Some airports connect to the wrong cities.