Forum Discussion
Full outer join
Hello all. I would like to use the picture from Microsoft as an example. After combine the left and right table, it becomes the merged table below. How can I get the last row CountryID show ...
Yes, you can do it in power query For it
watch my video here
https://1drv.ms/v/s!AiUZ0Ws7G26RhkcKM6nHiGi6ziQt?e=J299WE
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhkY9ZiZGmrFfbq7O?e=KLRbbs
Thanks for your video! I found my example is not enough for what I want.
If ID in Table 1 consists 1, 2, 3, 5
and ID in Table 2 consists 1, 2, 4, 6
and the ID in joined table shows all of the ID in the same column, which are 1, 2, 3, 4, 5, 6?
