Forum Discussion

ells69's avatar
ells69
Icon for Helper I rankHelper I
3 years ago

alternative to merge to retrieve description fields

In M  I have a fact query with many keys in. Lets Call it "Fact". I have several querys that have the matching description LKUP_Product which consists of [ProductID], [ProductName],[Product Colur] ...
Need Help
Tips and Tricks
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

Hi, ells69 

1. Create a record of products as p_rec = Record.FromList(LKUP_Product[ProductName], LKUP_Product[ProductID])

2. add new column to Fact (or transform existing) Table.AddColumn(Fact, "ProductName", each Record.FieldOrDefault(p_rec, [ProductID], "none"))