Inverting a join

amotleyamotley Member Posts: 17 Contributor I
edited July 30 in Help

Is there a way to invert a join in rapidminer? I am using an inner join. So instead of getting the output to be all the examples that match between the two data sets, you get a list of all the examples that do not match.

Is this possible?

Tagged:

Answers

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

    Hi,

     

    isnt that set minus? Otherwise you can maybe simply use an outer join and filter for missings?

     

    ~Martin

    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 290   Unicorn

    Hi,

     

    I blogged about generic/advanced joins just two days ago:

    http://datascientist.at/2016/06/generic-joins-in-rapidminer/#english

     

    This could be interesting for your application. Your join condition would be "e1 != e2". 

     

    Set Minus is not exactly a join as it is one-sided. 

     

    You could also use an Outer join, keep both join attributes and then filter out those that have non-missing join fields. 

     

    Be careful, this will get you a huge number of resulting rows. 

    mschmitz
Sign In or Register to comment.