Forum Discussion

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago
Solved

Help with Group By

Hello everyone.   Let's say I have a table like this, where I need to remove all rows related with workers which doesn't have any True value in status. How can I achieve this behaviour? W...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hello, mlsx4 

    let
    Source = your_table_like_this,
    group = Table.Group(Source, "Worker ID", {{"wid", each _}}), 
    select = Table.SelectRows(group, (x) => List.AnyTrue(x[wid][Status])),
    expand = Table.ExpandTableColumn(select, "wid", {"Column1", "Column2", "Status"})
in
    expand
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

Hello, mlsx4 

let
    Source = your_table_like_this,
    group = Table.Group(Source, "Worker ID", {{"wid", each _}}), 
    select = Table.SelectRows(group, (x) => List.AnyTrue(x[wid][Status])),
    expand = Table.ExpandTableColumn(select, "wid", {"Column1", "Column2", "Status"})
in
    expand
mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Brilliant, as always!

 

Thank you so much AlienSx