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

User: "sgnarkhede2016"
sgnarkhede2016
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

AI Studio
Sort by:
1 - 2 of 21
    User: "MartinLiebig"
    MartinLiebig
    Altair Employee
    Hi,
    I think you want to aggreagte with Group by Customer and Concat of Product as aggregation?

    Best,
    Martin
    User: "Telcontar120"
    Telcontar120
    New Altair Community Member
    Or Pivot on Customer by Product, and then concatenate product attributes.
Quick Links