Forum Discussion

Praiciya-07's avatar
Praiciya-07
New Member
2 years ago

Finding name Top Parent Name for Sub-Child in Power Query

Hi All, I am having Table like the below image in the Power Query ,  I need to find a result like this , Finding top parent name for each childs in Power Query.    
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Praiciya-07 , The best duplicate the table and remove columns other than Object id and name and remove duplicates and then use merge query and join the parent id of the current table with the object id of new table.

 

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo

Praiciya-07's avatar
Praiciya-07
New Member
2 years ago

Result is not coming as per the expection uisng above method, any other way to find