Hello,
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 ?
Regards