how to match city code and airport code

Question

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 Answer

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 Answer

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

Attached is the sample workflow.