Skip to content

Duplication Rule (duplication) ​

Handles duplicate records in the dataset for the input conditions.

FieldDescriptionRequired
conditionsConditions to operate againstβœ… Yes
columnsColumn to duplicate as well as destinationβœ… Yes
sortArray of columns with which to sort byβœ… Yes
duplicate_onField to determine duplication groupsβœ… Yes

Example: ​

json
{
  "type": "duplication",
  "conditions": [
    {
      "expressions": [
        {
          "column": "age",
          "operator": ">",
          "value": 18
        }
      ]
    }
  ],
  "columns": {
    "source": "name",
    "destination": "duplicated_name"
  },
  "sort": [],
  "duplicate_on": ""
}

Behavior: Processes duplicate records based on customer ID.