Forum Discussion

83dons's avatar
83dons
Icon for Helper III rankHelper III
1 year ago
Solved

Remove rows from one table from another larger table

Hi I have a Master table and a Duplictaes Table. I require to remove all rows from the Master Table that are in the Duplicate table. The columns are identical in both tables. Both tables have StaffID...
Need Help
  • Ashish_Excel's avatar
    Ashish_Excel
    1 year ago

    Hi,

    in each table remove the extra space from both headings.  This simple M code in Power Query works

    let
    Source = Table.RemoveMatchingRows(master,Table.ToRecords(duplicate),{"StaffID","RoleID"})
in
    Source

     Hope this helps.