Видео

Thank you so much. This helped a lot.

Thank you so much

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

can we import multiple csv files?

Thank u!

Thanks 😄

This was enormously helpful to me. Thanks so much!

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?

2 year old video and still gave me the best method, Thanks alot

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

Thanks!! Very helpful

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.

Absolutely awesome video! Thanks

You're simply awesome!

I love you. Thank you for this.

Hello, I have two similar lists, but in my case i want to remove the countries that are in europe from the 1.6m rows CSV. any ideas on how to do it?

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

Thanks - this is slower but simpler for those of us who dont have SQL experience (the go to for this stuff!). Can you match two columns? E.g. let's say county and sales date April in your example?

Thank you very much.

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

Is there a way to do it without adding column? Thanks 😊

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, can you please show how we can convert csv file with millions of data into excel . Like i want to export all those millions data into excel. Thank you

Thanks for the help! Important note: Do not changetype for any of the columns before doing the merge action, this gives errors.

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 . Can you help me in this.

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?

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

its tooo fast, could not understand anything.

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

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

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

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?

Great! Thanks for your video.

Good example! Thank you!

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

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

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.

Does the order of the columns being compared matter?

Very useful thanks!

I be carefull with this since this can trigger anti cheat possibly, regardless they should be adding an open all lootboxes at once option already anyway.