Altair RISE

A program to recognize and reward our most engaged community members

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

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

AI Studio

Hi,

I think you want to aggreagte with Group by Customer and Concat of Product as aggregation?

Best,

Martin

Or Pivot on Customer by Product, and then concatenate product attributes.