Forum Discussion

Renato_mon's avatar
Renato_mon
Frequent Visitor
3 years ago
Solved

Group by text and result only differences.

Hello,   I'd like to group by text and result only the differences between each grouped row. I appreciate the help! Thanks   The result I expect: Product market Part x1 AX2 ZZZ x2...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hi, Renato_mon 

    let
    Source = your_table,
    g = Table.Group(Source, "Part", {{"Count", each Table.RowCount(_)}, {"a", each _}}),
    flt = Table.SelectRows(g, each ([Count] = 1)),
    z = Table.Combine(flt[a])
in
    z
jgordon11's avatar
jgordon11
Resolver II
3 years ago
let
    Source = --- code for your source table ---,
    tbl = Table.NestedJoin(Source, {"Product", "Part"}, Source, {"Product", "Part"}, "Join", JoinKind.LeftOuter),
    tbl1 = Table.RemoveColumns(Table.SelectRows(tbl, each Table.RowCount([Join]) =1), {"Join"})
in
    tbl1