The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.

Join: Inner/Outer left/right?

dragoljubdragoljub Member Posts: 241 Contributor II
edited October 2019 in Help
I am slightly confused by the join operator.

There are 4 types. For clarity what does each join type preform?

When only adding attributes to a small number of samples to a large group should 'outer' or 'left/right' be used?




  • Options
    landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    I think these types are equivalent to what is used in the database domain. Please take a look at

  • Options
    dragoljubdragoljub Member Posts: 241 Contributor II
    Thanks this makes sense.

    Inner Join = Only add attributes for matching IDs (intersection of IDs) (may remove some samples)

    Left/Right Join = Only adds attributes to samples contained in the left/right data sets (keeps all samples from left or right) (can add missing values)

    Outer Join = Joins all records from both datasets and adds missing values for attributes not shared between samples.

    Hope this helps someone. Maybe we should add a wiki link in the help of this operator.

Sign In or Register to comment.