Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello friends, I'm trying to group the dataset as shown below, but I'm not getting it. I think it's possible to use a custom key, but I don't know which SQL Expression to use. Has anyone ever had to do something like this?
Input:
order | product | value
100 | product A | 10.00
100 | product B | 5.00
Output:
order | concat_product | sum_value
100 | product A, product B | 15.00
Thank you,
Portes, Leo
[Edit]: Solution (Image)