[SOLVED]Add a rank column

texnotitexnoti Member Posts: 3 Contributor I
edited November 2018 in Help
Hi all!

Just started with RapidMiner.
Got so far that I'm calculating what I want.
Ended up with this result:
38.898
42.052
43.455

Now, in the next step I only care about what place it is, so how do I add a column with 1, 2, 3?
It's not always three, it varies.

Kind regards
thomas

Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,111  RM Data Scientist
    Hi,

    Sort and Generate ID should do it.

    ~Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • texnotitexnoti Member Posts: 3 Contributor I
    Hi, yes it did.
    But...

    now I'm trying with Loop Values and Filter because I got data as:
    1,23.256
    1,35.655
    2,56.899
    2,57.122

    Tried condition_class = attribute_value_filter but I get an error.
    How should I set up the filter to process 1's and 2's (and 3's, 4's and ...) separate?
  • texnotitexnoti Member Posts: 3 Contributor I
    Ok, got it!

    attribute=%{loop_value}

    Now it's just a matter of merge, right?

    Thanks!
  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,111  RM Data Scientist
    propably,

    maybe you need to know that append also appends collections.

    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.