The only thing I can think of is rather slow to run, especially if you are looking up a lot of csc_posture_name_key values, but it ought to work. (If anyone has a working solution that doesn't use map , then go with that!) But try this: | inputlookup CSC_value | lookup CSC_posture_name _key as csc_posture_name_key output name as posture_name | lookup CSC_tree _key as csc_tree_key output name as tree_name | map search="| inputlookup CSC_posture_value where csc_posture_name_key=$csc_posture_name_key$ | where min<=$value$ AND $value$<=max" ... View more