Hello,
My dataset is like this :
ID ticket | Date | Operator |
---|---|---|
1 | 01/01/2023 | A |
1 | 01/01/2023 | B |
2 | 01/01/2023 | C |
I’d like to have a calculated field with all “Operator” of the ticket concatenated, like that :
ID ticket | Date | Operator | Operators |
---|---|---|---|
1 | 01/01/2023 | A | A,B |
1 | 01/01/2023 | B | A,B |
2 | 01/01/2023 | C | C |
Is it even possible ? I see sum, avg, but it’s only for numbers, not strings …
Thanks