match 3 letter city code or 3 letter airport code with city name

[merypals]

Hi everybody, 

Is there a way to join two data sets using a 3 letter city code from File1 and city name from File2?

File 1

airport code	airport name
SXW	Sauren
NDV	USN Heliport
EAP	Euro Airport Basel-Mulhouse-Freiburg Airport
NET	New Bight
MSK	Mastic Point

File 2

City name

Sauren

Mastic Point

Bahamas

Basel

Anascotia

[Raj]

can you share the expected output

[Kottapally_Ramesh]

Share the sample output, given data is not sufficient to perform the join function. 

[merypals]

the expected output is this 😊

airport code	airport name	city name
SXW	Sauren	Sauren
NDV	USN Heliport	Anascotia
EAP	Euro Airport Basel-Mulhouse-Freiburg Airport	Basel
NET	New Bight	Bahamas
MSK	Mastic Point	Mastic Point

[FinnCharlton · Accepted solution]

Hi @merypals , you need additional context to join these data sets. I would recommend a lookup table of airport codes and their cities. You can find them online, for example here: https://www.nationsonline.org/oneworld/IATA_Codes/IATA_Code_A.htm

[merypals]

Thanks! I will try that :)

[Raj]

Hi @merypals , this is incomplete information
we need to have a secondary table as well with primary key and City name so we can join them

else result is not possible with this data