Skip to main content

Join properties

Properties to configure in order to combine your records using Join. You can add as many keys as you want in the processor configuration.
Configuration
Property Configuration
Join type
Select the desired join type in the list:
  • Inner join: use this join type to compare two datasets that have matching column values and list all the resulting pairs. Values that do not match each other are being ignored in the result set.
  • Left outer join: use this option to retain all values of the left dataset in the joined output list. Values that do not match any rows in the right dataset will be listed in the result set as NULL.
  • Right outer join: use this option to combine left and right outer joins. Values that do not match any rows in the left dataset will be listed in the result set as NULL.
  • Full outer join: use this option to combine both left and right outer joins. Every value that has no matching value will be listed in the result set as NULL.

For more information, see Additional information about join operations.

Merge input records Enable this option in order to even and group the hierarchical structure of both left and right datasets.

By default, if you do not enable this option, the left and right datasets will be outputted with the same structure they had before the join operation.

Conditions
  • Left key: Select or enter the path to the existing record in the left dataset. Auto-completion is available while typing.
  • Right key: Select or enter the path to the existing record in the right dataset. Auto-completion is available while typing.
Info

Property

Configuration

Description (optional)

Enter a description for the processor.

To rename the processor, click the Rename Rename icon next to the default name of the processor.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!