🎉 🎉   RAPIDMINER 9.5 BETA IS OUT!!!   🎉 🎉

GRAB THE HOTTEST NEW BETA OF RAPIDMINER STUDIO, SERVER, AND RADOOP. LET US KNOW WHAT YOU THINK!

CLICK HERE TO DOWNLOAD

🦉 🎤   RapidMiner Wisdom 2020 - CALL FOR SPEAKERS   🦉 🎤

We are inviting all community members to submit proposals to speak at Wisdom 2020 in Boston.


Whether it's a cool RapidMiner trick or a use case implementation, we want to see what you have.
Form link is below and deadline for submissions is November 15. See you in Boston!

CLICK HERE TO GO TO ENTRY FORM

Concatenate first and second value of an attribute

die_eikedie_eike Member Posts: 4 Newbie
Hello community!

I have an example set with two attributes and two values. "Word" is nominal, "total" is numerical.

word    total
a          10
b           6

want to do the following: generate new attributes in which the first and the second value are concatenated and appear in the same row:

word(concat)  total(concat)
a_b                  10_6

I will place this subprocess into a loop, looping over 240 example sets with different values for "word" and "total"; so I cannot use any fixed value for the concatenation, but need to identify the values I want to concatenate (which are of the same attribute) by their order (first_second).

I tried generate attribute but couldn't find out how to identify the values by their order. I also tried to transpose the whole thing which gave me an error because of duplicate IDs.

I spent the whole day searching for operators to solve this apparently simple process but did not yet find a solution. Maybe somebody has an idea on this?

Best,
Eike

Best Answers

Answers

  • die_eikedie_eike Member Posts: 4 Newbie
    Thanks a lot kayman! I should have known that aggregate would do the trick! ;)
    Just hypothetically, what would I do if I had more than 2 values (let's say 10) and would like to concatenate some of them by their order, e.g. the first, third and seventh value?

    Best,
    Eike
    Tghadially
  • die_eikedie_eike Member Posts: 4 Newbie
    Thumbs up!
    Tghadially
Sign In or Register to comment.