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

Name

Enter a display name for the Join processor.

Description (optional)

Enter a description for the Join processor.

Join dataset

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.

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.