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.

[@jessicachang7204]

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! :-)

[@pabloghernandez802]

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.

[@guidam313]

Absolutely awesome video! Thanks

[@nagabhushanbgbg7787]

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

[@trinipepper22]

I love you. Thank you for this.

[@mirrrvelll5164]

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 =)

[@Over50andthriving]

Thanks!! Very helpful

[@GirlsDriving99]

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.

[@asmat561]

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 ✌️

[@kc329191]

Good example! Thank you!

[@karthicr6568]

Thank you very much.

[@Amit_Singh777]

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

[@Anonymous19539]

Very useful thanks!

[@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?

[@georgefandamu5115]

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

[@MarcoMagal]

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

[@SpAz0715]

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?

[@yourexcelsolution2830]

Yes you can match N number of columns from Table A to N on Table B. The size of the tables doesn't matter, but you have to specify which columns to match on

[@tigerlils3910]

Thank u!

[@sanjaysinhparmar5244]

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

[@kitty1977]

Does the order of the columns being compared matter?

[@heretocomment864]

Not at all!

[@kitty1977]

@@heretocomment864 great thanks.

[@shawn2296]

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

[@jocelynbeier4991]

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

[@eleanorkeddy9671]

Hello,
This would be really useful. Did you ever find out if this is possible?

[@JiffyDealer]

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