Join Activity
The Join activity enables the combination of two distinct datasets. It facilitates this by matching records based on specified column references from each dataset, producing a new, consolidated dataset.
| Field | Description | Requirement |
|---|---|---|
| Dataset name | Name of the dataset which will be used for operations. | Required |
| Dataset name 2 | Name of the second dataset selected for processing. | Required |
| Source reference | Source column name reference in which the dataset will be joined. | Required |
| Destination reference | Destination column name reference in which the dataset will be joined. | Required |
| New dataset name | Name of the dataset which will be created. | Required |
Action Types & Examples
Dataset name
- Format: string
- Example Result:
dataset1
Dataset name 2
- Format: string
- Example Result:
dataset2
Source reference
- Format: string
- Example Result:
Id
Destination reference
- Format: string
- Example Result:
Plaka
New dataset name
- Format: string
- Example Result:
newDS
Implementation Examples
Field Setup - Dataset name - Dataset name 2 - Source reference - Destination reference - New dataset name
Execution Parameters - Dataset name: dataset1 - Dataset name 2: dataset2 - Source reference: Id - Destination reference: Plaka - New dataset name: newDS
Technical Notes
Depending on the size of the datasets and the order in which they are processed, different results will be obtained.