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.
Solved! Go to 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.