🥳 RAPIDMINER 9.9 IS OUT!!! 🥳

The updates in 9.9 power advanced use cases and offer productivity enhancements for users who prefer to code.

CLICK HERE TO DOWNLOAD

How to generate id for below scenario.

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

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,937  RM Data Scientist
    Hi,
    Group Into Collection with Group by Cust and then Loop Collection and Generate ID inside.

    Best,
    Martin
    - Head of Data Science Services at 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: 332  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.