What Join should I choose in Power Query

[Anonymous]

Hi Experts,

What type of Join should we use in Power Query to get the output like this? Please help!

[serpiva64]

Hi,

you need a full outer and then use conditional column to obtain the complete column you need.

Otherwise, the easiest, you can append to the second table the first one and then delete duplicate rows in your ID.

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[amitchandak · Accepted solution]

@Anonymous , First Append the two tables in a new table and remove the value column.

And then merge new table and table 2 on the left join and add only value column

Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query