Merge Activity

The Merge activity combines two distinct datasets into a single output. It supports merging datasets even if they have different column structures, appending the second dataset's content after the first. This flexibility allows for combining diverse data sources without requiring a uniform schema.

Field	Description	Requirement
Dataset name	Reference name of the primary dataset for the operation.	Required
Dataset name 2	Reference name of the secondary dataset to be merged.	Required
Merge type	Specifies how the two datasets are combined: `Vertical` or `Horizontal`.	Optional
New dataset name	Reference name for the resulting merged dataset.	Required

Action Types & Examples

Vertical

Format: string
Example Result: "Vertical"

Horizontal

Format: string
Example Result: "Horizontal"

Implementation Examples

Field Setup - Dataset name - Dataset name 2 - Merge type - New dataset name

Execution Parameters - Dataset name: newDS - Dataset name 2: newDS2 - Merge type: Vertical - New dataset name: mergeDS

Technical Notes

When merging datasets with differing column structures, the activity intelligently appends new columns from the secondary dataset to the primary. For Vertical merges, the activity aligns columns by name where possible, otherwise appending unique columns. For Horizontal merges, datasets are combined side-by-side based on row index.