Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

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

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

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,529 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
  • Telcontar120Telcontar120 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.