Skip to content

Minus Activity

The Minus activity calculates the difference between two datasets. It returns records present in the first dataset but absent from the second. For accurate results, both datasets must share an identical column structure.

Field Description Requirement
Dataset name Reference name of the dataset to be used as the primary for operations. Required
Dataset name 2 Reference name of the second dataset selected for comparison. Required
New dataset name Reference name for the dataset that will be created to store the result. Required

Action Types & Examples

Result Dataset

  • Format: Dataset (Table of Records)
  • Example Result: minusDS

Implementation Examples

Field Setup - Dataset name: ${newDS} - Dataset name 2: newDS2 - New dataset name: minusDS

Execution Parameters - Dataset name: ${newDS} - Dataset name 2: newDS2 - New dataset name: minusDS

Technical Notes

The Minus activity operates by comparing each record in the first dataset against the entire second dataset. It identifies and returns only those records uniquely present in the first dataset. For successful execution and accurate results, both datasets must possess an identical column structure and data types.