Hi,
I am trying to combine the distinct value from multiple rows in a column with Beast mode.
Here is an example of my file:
Field A | Field B | FieldC |
A | 1 | 111 |
A | 2 | 222 |
A | 3 | 333 |
A | 4 | 333 |
B | 5 | 111 |
B | 6 | 444 |
C | 7 | 555 |
I would like to have:
Field A | Field B |
A | 111, 222, 333 |
B | 111, 444 |
C | 555 |
In this case I have a concat but I would also need to do a distinct sum potentially.
Any ideas on how I can achieve this.
Thanks.