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

sgnarkhede2016
sgnarkhede2016 New Altair Community Member
edited November 2024 in Community Q&A
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
Tagged:

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Hi,
    I think you want to aggreagte with Group by Customer and Concat of Product as aggregation?

    Best,
    Martin
  • Telcontar120
    Telcontar120 New Altair Community Member
    Or Pivot on Customer by Product, and then concatenate product attributes.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.