Forum Discussion
What Join should I choose in Power Query
Hi Experts, What type of Join should we use in Power Query to get the output like this? Please help!
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
serpiva64
Solution Sage
Solution SageHi,
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 !