Excel PowerQuery: Match multiple columns between two tables

Matching (joining) multiple columns between two tables in Excel PowerQuery.

Note:
Try "Inner" Join instead of "Left Outer" to skip the filtering step later on.
"Left Outer" will keep ALL records from Table A, even those which do not have a match in Table B.
"Inner" will keep only the records from Table A which have a match in Table B.

[pabloghernandez]

Thanks for the info!

Note: To only create a connection, click the drop down and select “Close and Load to” In the Power Query editor instead of clicking save. This will Open the option to select a new sheet or Only create a connection. Once the connections are established right click on the navigation pane and select merge from the options.

[jessicachang]

You are a genius! Thank you so much!
NO JOKE, your tutorial just may save someone's life one day with the data I work with and what my goal was with this tutorial! :-)

[nagabhushanbgbg]

Thank you so much for this content it's really a survival tips

[asmat]

You need to click on close and load, and click on the second option wich is "close and load in". And here you'll have to choose the fourth option to create only Connexion without having a new sheet. Hope it's useful ✌️

[mirrrvelll]

Nice trick....especially that with custom fx - I have been looking for the "good" approach, merging/Joins/M....this actually gave me the best comparison within my custom table that has 10+ columns =)

[japaneseimmersion]

THANK YOU! I was struggling with this, it did not work when I tried it another way because it always kept the matched rows and removed the unmatched rows, no matter what I tried changing. Converting everything to tables first solved it.

[yahsaki]

Hello, I think you wouldn't need to use power query to begin with. Just make the connection by using "relationship" under Data tag, then you can do the merging?

[georgefandamu]

how can you match the positive and negative amounts in excel power query

[Amit_Singh]

Hi, I have two files(say excel) from two two different sources..I want to compare these two files for any difference (if any)... After comparison I want to do the same comparison(basically automate) for other years in power query without manually doing the same thing. Can you help me in this?

[Tyemagic]

Instead of closing with the X, use "close and load to..." and save only as a connection

[sanjaysinhparmar]

how do i extract unique values in from all multiple(three or more) columns in excel?
without power query

[shawn]

when u click close
u can close and load and it wont open a sheet

[MarcoMagal]

Choose Data | Query Options | Data Load.
Under Default Query Load Settings choose Load to Data Model

[kitty]

Does the order of the columns being compared matter?

[jocelynbeier]

Is there a way to Merge two tables, then append the unmatched rows?

[SpAz]

What if i have 10 columns on Table A, but 17 columns on Table B? Will it still be able to tell me what matches and what doesn't in certain rows?

[JiffyDealer]

Using column names that also mean cell names made this video confusing.