View My Drafts
Matching Column contains all the fields of hierarchy like:ssssss-ssd-ddd-ffffsss-ssd-ffffaaaaaa-ffs-ggg-sssaaa-fffwrrr-eee-pppand 'Table'[Level 2]I am comparing the values after splitting the columns.
'Table'[required field description] field is that I want to populate the values frombut still got the blank values.Also, with PATHITEM() I get the values from hierarchy, I want the description of those values in the hierarchy.eg: for hierarchy value "aaa" - I need "Apple"for hierarchy value "aaa-ffff" - value is "orange"How to pick those values. I tried lookup function as wellThanks :)
I am still trying to find out the solution and understand this behavior.. Both table contains same key which is column contains all hierarchy values like:ssssss-ssd-ddd-ffffsss-ssd-ffffaaaaaa-ffs-ggg-sssaaa-fffwrrr-eee-ppp
but when I am trying to lookup particular values, why its showing all blank rows.eg. in table1 for column Level1
when I try to apply lookupvalue() or function with firstnonblank() applied the same blank rows returns. I just need to pull the values for these field from other table.