How to generate id for below scenario.

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

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,453 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
  • hyukiehyukie Member Posts: 2 Contributor I
    hello i have same problem with this
    can u explain step by step because im still beginner for RM

  • yyhuangyyhuang Administrator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 363 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.

    hyukie
Sign In or Register to comment.