Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • danextian's avatar
    danextian
    3 years ago

    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.

     

     

     

danextian's avatar
danextian
Super User
3 years ago

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.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI danextian Thank you very much.

    Could you please also kindly tell which Join Kind I should select if I only want to get the difference rows?

    • danextian's avatar
      danextian
      Super User
      3 years ago

      Use Left Anti. This should keep only the rows that are in the first table. If a row exists in the other table, then that will be filtered out.