Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query with add rows with conditions

Hi! I am want to expend my table which records child-parent relationships. As you see, I want to create a row with for "abc" and set its parent as null.  How can I do it with powerquery? thanks! ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    Modify this line a little bit

     Custom1 = List.Distinct(List.Difference(Source[Parent],Source[Child])),
Anonymous's avatar
Anonymous
Not applicable
5 years ago

There is a problem with method one.

If "abc" appears twice, two rows will be added.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

Modify this line a little bit

 Custom1 = List.Distinct(List.Difference(Source[Parent],Source[Child])),