Forum Discussion

Noeleke1301's avatar
Noeleke1301
Icon for Helper III rankHelper III
2 years ago
Solved

Lookup with wildcards (sequential lookup)

Hi all,   I'm trying to solve the following problem. I have a main table with values in each column. I want to look up an Id from another table.   Unit Debtor Location Id A ABCD AMS (...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago
    Id =
    var d = [Debtor]
    var l = [Location]
    var f = filter(Table2,[Debtor]=d && coalesce([Location],l)=l)
    return if(countrows(f)>0,maxx(f,[Id]))
     
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
Id =
var d = [Debtor]
var l = [Location]
var f = filter(Table2,[Debtor]=d && coalesce([Location],l)=l)
return if(countrows(f)>0,maxx(f,[Id]))