Forum Discussion
Left Outer Join Issue
Hi guys, I have an issue regards Left Outer Join, where I would like to join the table from the "Block_Log_Base" table based on "Bus_OBJKEY" to the "1Head" table based on "Bus_OBJKEY" as well, in...
Hi speedramps ,
Thank you for your suggestions, unfortunately, non of the suggested solution worked in my case. I will try to find alternative solutions.
Regards,
Matas
Are you using import mode?
Try this
Write down one key number that has multiple output records.
In power query editor
In table A just keep records = key
In table B just keep records = key and nulls
Run your join and check output.
This wont fix your problem but it might make it easier to spot the problem with less records.
Please click thumbs up to give kudos, I tried to help you lot. Thank you.