Here is the scenario: I have master data table, and the another table is Countries and Race. The master data has several columns + countries, with the Race column with blanks. So when I receive new data set I paste it in the master data table replacing the previous/old data and I have to place the race related to each country. Some rows don't have country because not all the individuals are foreigners. My question is after all these queries you set up, if I delete the old data from the master, paste new data set, will the query updating by refreshing, or I have to set up the whole process making the queries? What should I do with the Country Column that has blank. Should I trick it? putting type blank on the Country row and put on the Race column from the Countries and Race list as 12-Unknown? then after merging I would get rid of the blank texting. There are 100, 1000 rows where you don't want to type the race manually or use combo box with excessive clicks and select the race that hurt your hands causing injuries.
Power Query is so much easier and I find there to be less chance of an error. You can also use custom columns to force it to find entries with similar naming formats. i.e. greg smith and gsmith.
Hello Sir thank you for the video. I have a question I don't know Vlookup but know Power query so can I do everything over Power query done by Vlookup?
Very clear and concise instruction. I love how he walks through each step even though it might a repeat of a previous step. That really helped me commit it to memory.
This is helpful but your example is too perfect/clean. All rows matched on your left join. Better example would to show messy data where you have a significant amount of mismatched data (15k rows match out of 29k)
I really enjoy your videos and the cadence you put to explain them. I am trying find a way for Power Query to exclude (without removing from data) certain data points. I can have two tables and the request is 'If you find this item don't bring it'. Access had a built query to 'exclude' the matching points from table.
Hi I need help I did this just that my spreadsheet has 100,000 rows and when i click load to table it takes forever to load , loading rows for 6 hours till its 1 billion rows.
Absolutely fantastic, super useful! Thank you.
Here is the scenario: I have master data table, and the another table is Countries and Race. The master data has several columns + countries, with the Race column with blanks. So when I receive new data set I paste it in the master data table replacing the previous/old data and I have to place the race related to each country. Some rows don't have country because not all the individuals are foreigners. My question is after all these queries you set up, if I delete the old data from the master, paste new data set, will the query updating by refreshing, or I have to set up the whole process making the queries? What should I do with the Country Column that has blank. Should I trick it? putting type blank on the Country row and put on the Race column from the Countries and Race list as 12-Unknown? then after merging I would get rid of the blank texting. There are 100, 1000 rows where you don't want to type the race manually or use combo box with excessive clicks and select the race that hurt your hands causing injuries.
The most valuable thing that is not covered in the video - „looking up“ by more than 1 column.
how can you match the positive and negative amounts in excel power query
Thanks a lot for this beautiful teaching and great way of explanation for beginners to can understand easily
Perfectly explained
Power Query is so much easier and I find there to be less chance of an error. You can also use custom columns to force it to find entries with similar naming formats. i.e. greg smith and gsmith.
The function I was needing was "merge queries" Thank you
Hello Sir thank you for the video.
I have a question I don't know Vlookup but know Power query so can I do everything over Power query done by Vlookup?
Very clear and concise instruction. I love how he walks through each step even though it might a repeat of a previous step. That really helped me commit it to memory.
This is helpful but your example is too perfect/clean. All rows matched on your left join. Better example would to show messy data where you have a significant amount of mismatched data (15k rows match out of 29k)
Thanks a lot for the video.. Could you include the link of the file, please?
I really enjoy your videos and the cadence you put to explain them. I am trying find a way for Power Query to exclude (without removing from data) certain data points. I can have two tables and the request is 'If you find this item don't bring it'. Access had a built query to 'exclude' the matching points from table.
Thank you and your preparations is very clear and easy to follow and i have watched lots of power query videos..so again thank you so much
thanks but i guess you don't have to convert it into "tables" to do that 1:46
Great videos good concept clearance😊
Clear and concise video. Thank
Great video! Very clear and simple!
Awesome
thank you
Love it!
Hi I need help I did this just that my spreadsheet has 100,000 rows and when i click load to table it takes forever to load , loading rows for 6 hours till its 1 billion rows.