How can I join the source data with an additional data set?
Joiners are configured in the Scoping section to combine source records with an additional dataset for advanced processing. You can use one of the following functions:
JOIN_OBJECT_CONNECTION- Combines source data with another Salesforce object or Custom Setting from a configured Connection.JOIN_JSON- Combines source data with a JSON array represented as a string.
How It Works
A Joiner operates as one of the following:
- Left Join - When matching keys are specified, each source record is paired with matching records from the additional dataset.
- Cross Join - When no matching keys are provided, each source record is paired with every record in the additional dataset.
Referencing Joined Fields
After joining, fields from the additional dataset can be referenced using:
$Joiner.FieldName
These joined fields can be used in:
- Scope Filter (Post Join) - for further data refinement
- Mapping - for applying field transformations using the joined values
Joiners allow you to augment source records with additional data sets, enabling more advanced transformations.