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.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi 83dons ,

Thank you for reaching out to Microsoft fabric community forum.


I wanted to check if you had the opportunity to review the information provided by Ashish_Excel and djurecic . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.