Deletes a set of rows in your dataset, based on a condition specified in the
delete transform is the opposite of the
keep transform. See Keep Transform.
|delete row:(dateAge >= 90)|
Output: For each row in the dataset, if the value in the
dateAge column is greater than or equal to
90, the row is deleted.
|delete||Y||transform||Name of the transform|
|row||Y||string||Expression identifying the row or rows to delete. If expression evaluates to |
delete row: (lastContactDate < 01/01/2010 || status == 'Inactive')
Output: Deletes any row in the dataset where the
lastContactDate is before January 1, 2010 or the status is
|Yes||Expression that evaluates to |