Forum Discussion

KieuVuong's avatar
KieuVuong
Frequent Visitor
3 years ago
Solved

Remove Duplicate based on multi-conditions

Hi all

I have one trouble working with Removing Duplicate with conditions in Power Query. Could you please help?

 

I have table with 3 columns as below:

 

Article  Strategy  Supplier
11 Same Main
11 Increase Main
12 Same Main
12 Increase Main
11 Same David
11 Increase David

 

I have requirement from my work as:

- If the Articles and Strategy are duplicate, then choose Supplier David (delete Supplier Main) --> example article 11

 

And the desire result is 

Article  Strategy Supplier
11 Same David
11 Increase David
12 Same Main
12 Increase Main

 

Could you please help me on that?

 

Thank you in advance!

Need Help
  • Jakinta's avatar
    Jakinta
    3 years ago

    You can try steps below after your Source step.

     

        Grouped = Table.Group(Source, {"Article", "Strategy"}, {{"A", each let t = _ in if  Table.RowCount (t) > 1 then Table.SelectRows(t, each ([Supplier] = "David")) else t , type table [#"Article "=number, Strategy=text, #" Supplier"=text]}}),
    Expanded = Table.ExpandTableColumn(Grouped, "A", {"Supplier"}, {"Supplier"})
in
    Expanded

1 Reply

  • Jakinta's avatar
    Jakinta
    Solution Sage
    3 years ago

    You can try steps below after your Source step.

     

        Grouped = Table.Group(Source, {"Article", "Strategy"}, {{"A", each let t = _ in if  Table.RowCount (t) > 1 then Table.SelectRows(t, each ([Supplier] = "David")) else t , type table [#"Article "=number, Strategy=text, #" Supplier"=text]}}),
    Expanded = Table.ExpandTableColumn(Grouped, "A", {"Supplier"}, {"Supplier"})
in
    Expanded