Forum Discussion
Solved
Connecting two columns in one table with one reference table without duplication
Dear community, I am trying to create a relationship between two columns in a table (call it "Flight information") that has flight schedule information and a table that contains details on origin...
Hi lucasiragusa
in this case I would duplicate the Airport Information table and connect one to the FROM and on to the TO
should not be a problem for a dimension table
Hi LivioLanzo,
The attached is a simplified example. I want to use the IATA code of the airport to retrieve info like name of the airport, latitude and longitude etc.
airport code to access
Hi lucasiragusa
in this case I would duplicate the Airport Information table and connect one to the FROM and on to the TO
should not be a problem for a dimension table