Merge Join
Description
Merge Join is a step in the Joins Plugin for Process Studio Workflows. Merge Join step is used to merge data sets coming from two input streams with a common key column. It can join the two streams on a given key as an Inner Join, Left Outer Join, Right Outer Join or Full Join and outputs a joined set with fields in the two sets. The input streams must be sorted on the join key for this step.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of the step. The step name should be unique within the workflow. |
| 2 | First Step | Used to specify first input step to the merge join (left). |
| 3 | Second Step | Used to specify second input step to the merge join (right). |
| 4 | Join Type | Select the type of Join. - INNER-Only rows having the same key in both datasets are included in the result. - LEFT OUTER-All rows from the first dataset are included in the result, along with empty values for non-matching keys in the second dataset. - RIGHT OUTER- All rows from the second dataset are included in the result, along with empty values for non-matching keys in the first dataset. - FULL OUTER- All rows from both datasets are included in the result, along with empty values for non-matching keys in both datasets. |
| 5 | Keys for 1st step | Used to specify key fields on which the incoming data is sorted. |
| 6 | Keys for 2nd step | Used to specify key fields on which the incoming data is sorted. |
| Buttons: | ||
| 1 | Get key fields | When clicked, it retrieves a list of fields from the step specified. |