Forum Discussion

elliotdixon's avatar
elliotdixon
Responsive Resident
10 years ago
Solved

Lookup two columns - Related()?

Hi All, I think I should be using the related function here but am not sure. Just want to do a lookup on another table   I have a locations table Location_ID Location Name 1 Mars...
Need Help
  • konstantinos's avatar
    konstantinos
    10 years ago

    You can try this 

    =
LOOKUPVALUE (
    locations[Location Name];
    locations[Location_ID]; routes[Location_from]
)
    & " to "
    & LOOKUPVALUE (
        locations[Location Name];
        locations[Location_ID]; routes[Location_to]
    )
cwayne758's avatar
cwayne758
Helper IV
10 years ago

Forgive me for distracting, but how are you plan on visualizing this data? 

 

I ask because I have been wanting to be able to show  'Routes' or 'Lanes' between countries but have been unable to do it seeing as I cannot plot 'Origin' & ' Destination' locations with the map. 

 

Was curious how you were visualizing 

 

 

elliotdixon's avatar
elliotdixon
Responsive Resident
10 years ago

hi cwayne758 I am just going to visualise this with a table. For some logging trucks going from forrests to ports and I just need a count of the trips. Not really sure how you could get that 'route' data onto a map. Will be interesting if possible though.

 

ED