Skip to main content

APPEND

Append rows from the current pipeline to another dataset.

Syntax​

APPEND tableReference [DISTINCT selection (, selection)*]

Parameters​

  • tableReference - The target dataset to append current pipeline rows to
  • selection - Field identifiers used for deduplication when DISTINCT is specified

Description​

The APPEND command adds rows from the current pipeline to another dataset. When you specify DISTINCT, only rows that are unique based on the selected fields are appended, preventing duplicate entries. The command performs type expansion to accommodate fields that exist in the current pipeline but not in the target dataset.