how to store distinct product values with respect to customer in differnt column

sgnarkhede2016
New Altair Community Member
Hello ,
I have below data i want to generate the "Distinct" column from that.
I have below data i want to generate the "Distinct" column from that.
Customer | Product | Distinct |
1 | Remittance | Remittance |
2 | Remittance | Remittance, Travel Card, Foreign Exchange |
2 | Travel Card | Remmitence,Travel Card, Foreign Exchange |
2 | foreign Exchange | Remmitence,Travel Card, Foreign Exchange |
3 | Travel Card | Travel Card |
4 | Travel Card | Remmitence,Travel Card |
4 | Remmitence | Remmitence,Travel Card |
5 | foreign Exchange | foreifn exchang |
Tagged:
0
Answers
-
Hi,I think you want to aggreagte with Group by Customer and Concat of Product as aggregation?Best,Martin0
-
Or Pivot on Customer by Product, and then concatenate product attributes.0