Deletes a set of rows in your dataset, based on a condition specified in the |
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 row:(expression) |
| Token | Required? | Data Type | Description |
|---|---|---|---|
| delete | Y | transform | Name of the transform |
| row | Y | string | Expression identifying the row or rows to delete. If expression evaluates to true for a row, the row is removed. |
Example:
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 Inactive.
| Required? | Data Type |
|---|---|
| Yes | Expression that evaluates to true or false |