200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Dear all
I have a question on merging 3 tables together with Left Outer
As this is one to many relationships, the row repeat if there are more than one record under the Primary Key.
I have attached the file for your reference
Appreciate your help
Eric
Thank you for this question. It gave me an opportunity to learn about Power Query. This was my first serious contact with the program. Therefore please don't value this response as an answer and bear with me for my ignorance.
I figured that the result you want is very similar (except for only one partial row) to a filter applied to the X_GestName column to remove all null values. Therefore I concentrated on a method how to integrate that filter in the query itself. As are most things about PQ's UI, it's surprisingly simple.
In the Power Query editor you have filter arrows in the caption row. Click on the one in the X_GuestName column and remove the checkmark against null.
As I said, this still leaves L34:O34 highlighted by you as undesirable in the result. I see no difference as compared to L33:O33 and therefore wonder whether I understand your question correctly. Please do get back here to explain what you need. And thank you again for giving me this opportunity to sharpen my wits on a real life problem. If I'm really lucky my effort was of help to you, too. I hope so.
