Forum Discussion

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...

3 years ago

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

Advocate II

3 years ago

When you say "difference", please define exactly what that means.

If I would add two more lines to the table, (x1, AX2, MMM) and (x2, AX2, MMM), what would be the expected result?

What if I did not add the above two lines, but (x1, AX1, MMM) and (x2, AX2, MMM), what would be the expected result?

Frequent Visitor

3 years ago

Hi nickvanmaele

"Difference" means only value that are unique in all Product and Market.

In the both question, the result will be the same. The Part MMM will use in two Product/Market.

Write in the other way with 2 examples:

My DB have about 100 Products for 10 Markets, each one with about 150 Parts (15000 rows).

I hope was clear with my doubt.

Thanks!