Join properties - Cloud

Talend Cloud Pipeline Designer Processors Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development > Designing Pipelines
EnrichPlatform
Talend Pipeline Designer
Properties to configure in order to combine your records using Join. You can add as many keys as you want in the processor configuration.

Property

Configuration

Configuration

Join dataset

Select the dataset to be combined with the input dataset.

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.

Output ignores data origin 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.

This processor uses the avpath syntax.

Right key

Select or enter the path to the existing record in the right dataset. Auto-completion is available while typing.

This processor uses the avpath syntax.

Info Description (optional)

Enter a description for the processor.

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