Concatenate string field value with a function

Is there any concatenation agg function in QuickSight ?

For example, suppose you have following dataset : (both column are string fields).

Customer, Product
A, P1
A, P2,
B, P3,
B, P4,
B, P5,

is there a way to display a table like this :

Customer | Product_List
A | P1, P2
B | P3, P4, P5

I’d like to create a calculated field like Product_list = concatenate ({Product},', ')
but I don’t find any agg function such as concatover or something like this

Do you have an idea about how to do this ?


Hi @bherard - please review this thread ConcatOver / ListAgg (Aggregate fields enumerating values / concat values).