Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Mcode:Error result If Look Up Value doesnt exist at Source table (should show as blank not "Error")

I have a table that looks up a value from another table namely LookUp table and Review table. I have below MCode in my custom column in Review table.   = (let currentLookUp = [UniqueValue] in Table...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    It takes time to scan so many rows while using Table.SelectRows, please try Table.Group suggested by CNENFRNL edhans 

     

    you need to put the code offered by CNENFRNL after your currentLookUp = [UniqueValue] like this and paste in the custom column

    =let 
  currentLookUp = [UniqueValue] 
in
  Table.Group("LookUp", "UniqueValueCol", {"Grouped", each _}){[UniqueValue=currentLookUp]}?[Grouped]?{0}?[CategoryValue]?

      

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

It takes time to scan so many rows while using Table.SelectRows, please try Table.Group suggested by CNENFRNL edhans 

 

you need to put the code offered by CNENFRNL after your currentLookUp = [UniqueValue] like this and paste in the custom column

=let 
  currentLookUp = [UniqueValue] 
in
  Table.Group("LookUp", "UniqueValueCol", {"Grouped", each _}){[UniqueValue=currentLookUp]}?[Grouped]?{0}?[CategoryValue]?

  

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Anonymous ,

 

Thanks for your solution below 🙂

 

=let

[currentLookUp = [UniqueValue] ,
a=
Table.Group(lookup, "UniqueValueCol", {"Grouped", each _}){[UniqueValueCol=currentLookUp]}?[Grouped]?{0}?,

b= if a = null then "No Category Value" else a[CategoryValue]][b]