EntrysetJoin
Introduction
This module accepts two Entrysets as inputs and joins them according to a set of Join constraints, in a manner similar to a SQL database's JOIN function.
Property Panel:
Join Type
- Inner
- Performs an inner join.
- Left Outer
- Performs a left outer join.
- Left Outer, Only Include First Matching Row From Right Entryset
- Performs a left outer join, but if multiple matches for a given left entryset row exist in the right Entryset, only the first will be included.
Matching Columns
- Left Column
- Chooses a left column by name to include in the join constraint.
- Right Column
- Chooses a right column by name to include in the join constraint.
Output
- Exclude Matching Columns From Right Entryset
- With this option checked, the columns used to match from the right Entryset will be dropped in the joined output.
- Apply Prefix to Column Names from Right Entryset
- Entrysets cannot contain multiple columns with the same name. If the joining of the right Entryset introduces columns with the same name as columns that exist in the left, they will have a prefix applied to make them unique. Optionally, you can have this prefix applied to all columns in the right Entryset.
- Prefix for Column Names in the Right Entryset
- Sets the prefix that will be used to make right Entryset columns unique, as described above.
Input Menu:
Set Left Entryset
Sets the Entryset that will be considered 'Left' for purposes of the join.
Accepted Datatypes:
- Entryset
- Any Entryset
Set Right Entryset
Sets the Entryset that will be considered 'Right' for purposes of the join.
Accepted Datatypes:
- Entryset
- Any Entryset
Set Matching Attributes
Sets join constraints.
Accepted Datatypes:
- Entryset
- An Entryset containing column names on which to join
Output Menu:
Get Joined Entryset
Gets the resulting Entryset.
Output Datatype:
- Entryset