Skip to Content
0
Jun 18, 2020 at 12:42 PM

HCI DS - Concatenate multi rows based on key

98 Views Last edit Jun 18, 2020 at 12:57 PM 3 rev

Hello,

We wish to combine multiple rows for a given key into one entry.

Already tried an aggregation with 'group_by' on product key, but I have to select an aggregation function on the Sales Organisation key, which is limited to avg, count, count_distinct, max, min and sum.

In SQL Server there is something like 'string_agg', but that's lacking in HCI DS.

Note : we have no idea how many possible sales organisations can be assigned.

Any idea?

Thanks,

Kevin

Attachments

concat.png (6.5 kB)