The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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?
Contributor II
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?
???
Thanks,
-Gagi
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?
???
Thanks,
-Gagi
Tagged:
0
Answers
I think these types are equivalent to what is used in the database domain. Please take a look at http://en.wikipedia.org/wiki/Join_(SQL).
Greetings,
 Sebastian
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.
-Gagi