Is there a way to take a value from one lookup or search and make it the field name for the other.
Example:
| eval idx=3
| lookup ltable1 idx OUTPUT location
| eval idx=5
| lookup ltable1 idx OUTPUT location AS location2
???| eval fname=value(location2) AS FIELD???
| lookup ltable2 location OUTPUT fname
example ltable1
idx,location
1,chi
2,lon,
3,nyc
ltable2
location,chi,lon,nyc
chi,NA,2,3
lon,6,NA,4
nyc,2,5,NA
wanting to Xref the 2 tables like a mileage matrix of sorts, therefore given chi as a value from ltable1 Xref to lon will get me 2.
... View more