Compare Tables for Unmatched Records in Excel with Power Query

[@jasfradique]

Thank you very much! I'm in the process of learning PQ and it's simply amazing. This idea will, for sure, be of great help on a routine task I have to go through every month at my work. You're a savior ;-)

[@DougHExcel]

Glad it was helpful!

[@shaktishukla7558]

thanks a lot Doug.... ❤

[@DougHExcel]

Welcome!

[@pasaman-_-lml6636]

Thanks. Your Power Query series is the best.

[@DougHExcel]

Hi Pasa Man -_- lml, thanks for the kind words!

[@Luciano_mp]

Nice, very helpful. thanks Doug.

[@DougHExcel]

Hi Luciano...you're welcome, glad you liked!

[@Mister_Bimmer]

Thank you Doug H

[@FRANKWHITE1996]

Nice work 👍

[@DougHExcel]

Thanks FRANKWHITE1996!

[@CharltonONeal]

This is great but how do you do if multiple tables?

[@konli]

there some cases its easer to do it in power query, but in other cases where is a bit more complicated , it is easer to do it in access, multiple tables, where the diferents tables are conected by a common column, example order number Access it ease to learn, and nobody can beat even power query

[@meha1233]

Thank you 👌

[@DougHExcel]

You’re welcome!

[@lhycelcm]

Thank you so much… my problem is solved ❤

[@DougHExcel]

Welcome 😊

[@konli]

there some cases its easer to do it in power query, but in other cases where is a bit more complicated , it is easer to do it in access, multiple tables, where the diferents tables are conected by a common column, example order number

[@kitty1977]

Can you show one matching 2 columns per table? Where for eg. If the same person has more than one email address like a secondary one and we want to get the rows that have both email addresses?

[@DougHExcel]

maybe this will give a idea kzbin.info/www/bejne/nKvJf2tqoKmknbc

[@surajkapure9300]

I want to show a MATCH & MISS MATCH text message beside the column how to do it.?

[@DougHExcel]

maybe try the left outer join and add a helper conditional column. kzbin.info/www/bejne/fZ2wd3WEhrqEh5o kzbin.info/www/bejne/fp2ygGRuqrijmJo

[@riazuddin7493]

Lets assume that we have two components of salary i.e. Basic and Conveyance an employee receives PKR100 and 200 respectively for these two components in the month of April and the same employee receives USD200 and USD100 respectively for the same components in the month of May. Can Power BI DAX give me the information in another table under column Basic and Conveyance as 100 and -100 for the same employee? Please note that we have more than 14,000 employees and every month I have to identify the same by looking for the variance in payroll and identifying the staff who receive different payments as compared to last month. Thank you for your help! if there are more information required I can share the sample file through email.

[@DougHExcel]

Hi Riaz Uddin, sorry 🙁....but try a post on the mrexcel.com forum!

[@konli]

Dont you think do to it in access ? Example: 1.- if I have excel sheet one: original orders for a shipments 2.-excel sheet 2 , shipments completed 3.-excel sheet 3. shipments paid In this case would it be easer to to it in access ? 1.-just attached the excel sheets in access 2.-Do a Query connect the 3 sheets by order number, and presto, you get all the information you want ??? There some cases it more easer do to it in power query 1.-example have 30 expense sheets by customer, in one folder 2.-Power query combine all of them in one table automaticaly 3.-and in that table , have pivot table reports that aplies for all of them.

[@khalidmajeed2886]

is it last-----------I am learning from it.

[@DougHExcel]

Hi Khalid Majeed, thanks for the comment!