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! :-)
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.
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 =)
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 ✌️
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?
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.
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?
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
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! :-)
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.
Absolutely awesome video! Thanks
Thank you so much for this content it's really a survival tips
I love you. Thank you for this.
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 =)
Thanks!! Very helpful
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 ✌️
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?
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.
Thank you very much.
Good example! Thank you!
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?
how can you match the positive and negative amounts in excel power query
Thank u!
Very useful thanks!
how do i extract unique values in from all multiple(three or more) columns in excel?
without power query
Does the order of the columns being compared matter?
Not at all!
@@heretocomment864 great thanks.
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
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?
Instead of closing with the X, use "close and load to..." and save only as a connection
when u click close
u can close and load and it wont open a sheet
Choose Data | Query Options | Data Load.
Under Default Query Load Settings choose Load to Data Model
Using column names that also mean cell names made this video confusing.