🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉

Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.

CLICK HERE TO DOWNLOAD

"Join two tables using several attributes as key attributes"

bzavalabzavala Member Posts: 19 Contributor I
edited June 2019 in Help
Hi! I need to join two tables using several attributes as key attributes. What I was doing was concatenate all these attributes and then using the new attribute as a key, but I want to know if there is any better solution than that.  In addition, generate concatenation operator only allows to concatenate two attributes at time, so I need to use a lot of boxes to generate my key attribute. So, is there any way to concatenate several attributes at the time? And is there any other way to join tables using several attributes? My solution works OK but my entire process looks huge while is very simple.
Thanks in advance.
Tagged:

Answers

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

    if you uncheck the "use id as key" option you can have a option to use several keys to match for joining.

    ~Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • bzavalabzavala Member Posts: 19 Contributor I
    I havent realized that I was able to add entrys to add more key attributes. Sorry for such stupid question. Thanks you!
  • bzavalabzavala Member Posts: 19 Contributor I
    And what about concatenating several attributes in only one step? s there a way to do that?
  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,127  RM Data Scientist
    puh, since generate aggragation has no concat, i do not know a single operator solution for this
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 574   Unicorn
    The Generate Attributes operator has concat(), that might help. 
  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,127  RM Data Scientist
    yep, but to that for several attributes you need to add a loop attributes or so around :-)

    So at least 2 operators.
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.