Join Transformation

Description

Joins data arriving from two payloads or legs (the left and the right) into a single payload.

Configuration

To add the Join Transformation to a stream, follow the steps below:

1. Ensure you have a use case open in the stream designer, this can be a new use case or an existing use case
2. From the toolbox on the left expand the Transformation option and scroll down until you can see “Join Transformation”
   • You can also use the search in the header to find the stream object quickly
3. Click and drag the Join Transformation from the toolbox onto the canvas
4. Rename the Join Transformation object by clicking into the text button on the action bar
5. Save the Stream by clicking the save button in the action bar
6. Hover over the icon for the stream object until it turns orange and then double click to open the configuration page
   • You can optionally use the configure option on the action bar once you have selected the specific stream object and then clicking this option
7. Configuration options
   • The drop-down allows you to associate this stream object with a specific collection. The default option is derived from the default specified against the specific use case and is generated left as the same option. If you do need to change it to another collection make the change by selecting the new collection in the drop-down.
8. Enter Select details
   • Select SelectList from drop-down list
9. Enter Join details
   • Select Type from drop-down list: Inner join, outer join, left outer join or right outer join.
   • Tick “At most one match per record” if at most one match per record should be returned
   • Tick “Context Provider” if the data coming one of the end points needs to be treated as context
   • Select Context Endpoint from drop-down list: Left or Right
10. To specify what the join needs to be performed on, click to add new rows.
    • Select left column, select operator and then select right column
    • Select Date-Diff Unit from drop-down list
    • Select Date-Diff Max from drop-down list
11. Click Apply on the action bar, and then save the stream using the save button.

Limitations

• None at this time

Release Notes