Thanks a lot for this beautiful teaching and great way of explanation for beginners to can understand easily
@luigibru8677Ай бұрын
Perfectly explained
@nancys.59682 жыл бұрын
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.
@Pedro_Israel2 жыл бұрын
The function I was needing was "merge queries" Thank you
@romyramsamy849411 ай бұрын
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
@toniotello9649 Жыл бұрын
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.
@josephthibault6999 Жыл бұрын
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.
@formedicaecm22192 жыл бұрын
Absolutely fantastic, super useful! Thank you.
@ekackon2 жыл бұрын
Clear and concise video. Thank
@oscarsantanafernandez57192 жыл бұрын
Great video! Very clear and simple!
@tutsecret4994 ай бұрын
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.
@Aj.K.R Жыл бұрын
Great videos good concept clearance😊
@shwetkumar1719 Жыл бұрын
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?
@georgefandamu51152 ай бұрын
how can you match the positive and negative amounts in excel power query
@OswinAriaSuryawinata8 ай бұрын
Thanks a lot for the video.. Could you include the link of the file, please?
@MrPorkered Жыл бұрын
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.
@loismathius87473 жыл бұрын
Love it!
@hawikamdani96922 жыл бұрын
thank you
@rolandougalde4141 Жыл бұрын
Awesome
@stanTrX Жыл бұрын
thanks but i guess you don't have to convert it into "tables" to do that 1:46
@jsx0328 Жыл бұрын
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)