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.
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! :-)
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 ✌️
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.
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 =)
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?
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
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?
![Quando Rondo - Grow Up [Official Music Video]](http://i.ytimg.com/vi/8zFnCg3BO4Q/mqdefault.jpg)
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.
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! :-)
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 ✌️
Absolutely awesome video! Thanks
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.
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 =)
Thank you so much for this content it's really a survival tips
I love you. Thank you for this.
Thanks!! Very helpful
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?
how can you match the positive and negative amounts in excel power query
Instead of closing with the X, use "close and load to..." and save only as a connection
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?
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
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?
Thank you very much.
Good example! Thank you!
Thank u!
how do i extract unique values in from all multiple(three or more) columns in excel?
without power query
Very useful thanks!
Choose Data | Query Options | Data Load.
Under Default Query Load Settings choose Load to Data Model
Does the order of the columns being compared matter?
Not at all!
@@heretocomment864 great thanks.
when u click close
u can close and load and it wont open a sheet
Is there a way to Merge two tables, then append the unmatched rows?
Hello,
This would be really useful. Did you ever find out if this is possible?
Using column names that also mean cell names made this video confusing.