Multi Join
Overview
The Multi Join macro joins up to five inputs on a given key field, using a Cartesian join. The input fields can (and should) be renamed on output using the Input prefix options to ensure that all output fields are unique. This macro outputs a single wide record containing all input fields, including both the joining and non-joining records. Whenever there is a key value that doesn’t join for a given input, that input's record is supplied with an all-null placeholder.
Multi Join macro configuration parameters
The Multi Join macro has a single set of configuration parameters.
Input field renaming
Parameter | Description |
---|---|
Input1...Input5 prefix | Text to prepend to input field names ensuring that all output field names are unique.
|
Join fields
Parameter | Description |
---|---|
Input1...Input5 | Fields on which the inputs will be joined. You may specify up to five fields.
|
Unjoined record handling
Parameter | Description |
---|---|
Include unjoined records | If selected, include records that failed to join in output.
|
Output unjoined last | If include unjoined records is selected, optionally append records that failed to join in output to the end of the data stream.
|
Configure the Multi Join macro
Select the Multi Join icon.
Go to the Configuration tab on the Properties pane.
Optionally, select Input field renaming and specify text to prepend to input field names.
Select up to five join fields in the Input1...Input5 boxes.
Optionally, select Include unjoined records to include records that failed to join on output.
If you selected Include unjoined records, you may optionally select Output unjoined records last.
Optionally, go to the Execution tab, and then set Web service options.