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 |
Solved! Go to Solution.
can you share the expected output
Share the sample output, given data is not sufficient to perform the join function.
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 |
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
Thanks! I will try that :)
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