The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 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.