Options

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

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
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

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist
    Hi,
    I think you want to aggreagte with Group by Customer and Concat of Product as aggregation?

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    Or Pivot on Customer by Product, and then concatenate product attributes.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.