Lookup expression with more then one lookupcolumn

General Discussion
1

Hi,
is there an extension to the lookup expression command, so that I can look up more then one column, e.g. something like

lookup(dataset,lookupValue1,lookupColumn1,lookupValue2,lookupColumn2,.....,noMatchValue,columnValue)

Thanks in advance,
regards

2

You can do this with the view() expression function in the Simulation Aids module, like so:try( view("Select resultcolumn Where lookupColumn1==args[0] And lookupColumn2==args[1]", dataset, lookup1, lookup2)[0,0], noMatchValue)