Grouping dataset by concatenating text column with separator

Options
lpdutra
lpdutra Registered Posts: 2 ✭✭✭✭

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)

order_test_dataset

compute_order_test_group

compute_order_test_group_2

Best Answer

Answers

  • lpdutra
    lpdutra Registered Posts: 2 ✭✭✭✭
    Options
    Hi Alex,

    It worked with this function, but I had to use it in "Custom aggregations" and not in "Custom key" as I had thought.

    string_agg("product", ',')

    Thanks a lot for the help,
    Leo
Setup Info
    Tags
      Help me…