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 generate id for below scenario.

sgnarkhede2016
sgnarkhede2016 Member Posts: 152 image Contributor II
in Help
Hello,
I have input data that contain multiple customers with transaction and unqiue msgdb id 
I want data like

Cust  MSGDB_ID  ORDERNO
101    3                      1
101    4                      2
102    5                      1
102    6                      2
103    7                      1
104     8                     1
I want to generate ORDERNO column how can i do that? 

Answers

  • MartinLiebig
    MartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 image RM Data Scientist
    Hi,
    Group Into Collection with Group by Cust and then Loop Collection and Generate ID inside.

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • hyukie
    hyukie Member Posts: 2 image Learner III
    hello i have same problem with this
    can u explain step by step because im still beginner for RM

  • yyhuang
    yyhuang Administrator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 364 image RM Data Scientist
    @hyukie, you can follow exactly the steps mentioned by Dr Martin. You would need to install the operator toolbox extension from market place.

Categories