Forum Discussion
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...
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]?
Hi Anonymous , edhans and , CNENFRNL
Sharing data in dropbox and uploaded a sample data from thousand of rows.
https://www.dropbox.com/sh/i5no71trb9cuxi6/AABJ3nyu6NeWlYQG0ghyMe9Ca?dl=0
Let me know your inputs.