Skip to main content
Skip table of contents

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.

  • Default: blank

Join fields

Parameter

Description

Input1...Input5

Fields on which the inputs will be joined. You may specify up to five fields.

  • Default: blank

Unjoined record handling

Parameter

Description

Include unjoined records

If selected, include records that failed to join in output.

  • Default: no

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.

  • Default: no

Configure the Multi Join macro

  1. Select the Multi Join icon.

  2. Go to the Configuration tab on the Properties pane.

  3. Optionally, select Input field renaming and specify text to prepend to input field names.

  4. Select up to five join fields in the Input1...Input5 boxes.

  5. Optionally, select Include unjoined records to include records that failed to join on output.

  6. If you selected Include unjoined records, you may optionally select Output unjoined records last.

  7. Optionally, go to the Execution tab, and then set Web service options.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.