Jun 29 2020 09:22 PM - edited Jul 02 2020 11:42 AM
Hello
Since some time ago, I got knowledge about a extremely good option of power query, "outer join", but I don't know why with my father laptop and with my personal computer I don't have this option, I was thinking about maybe my father has a cheap version of office, but my excel is the best version of Excel 2016, the Professional Plus version, and when I try to merge a query, it just says "only include matching rows" like a check option and I remember with my job laptop, I was using options like "outer join" and there are another options with a part named "join kind".
Can you help me to get that option outer join available? I really can't understand how it isn't available since I have the professional plus version.
full outer join is the same thing that "outer join"
Just extra information
Jul 02 2020 03:55 PM - edited Jul 03 2020 01:40 PM
Solution@alemicrosoft well, here I don't have answers, but by a real time chat support from Microsoft I got a solution, a full update 2020 of this office 2016, and my power query is now working well, giving it a solution to this problem still with office 2016 (I don't like for now the 2019 version, thanks for the support team I have now the 2016 version working well)
Jul 02 2020 03:55 PM - edited Jul 03 2020 01:40 PM
Solution@alemicrosoft well, here I don't have answers, but by a real time chat support from Microsoft I got a solution, a full update 2020 of this office 2016, and my power query is now working well, giving it a solution to this problem still with office 2016 (I don't like for now the 2019 version, thanks for the support team I have now the 2016 version working well)