Forum Discussion
Compare Data from different data source and delete the difference
Hi I would like to use the Power Query to delete the difference between 2 different data sources. One dada source is Share point list. The columns are RequestNumber, Title, Status, Member ,ID an...
Hi Anonymous ,
In Power Query, you can use merge to compare a column in one table with the column in another. The innerjoin type will keep only those rows that are found in the other table. Please see attached pbix for reference.
You can do merge query with Inner join and then delete the additional column.
Then remove the additional column.
HI SandeepSugandh Thank you very much.
Could you please kindly tell which Join Kind I should select if I only want to get the difference rows?