Retains a set of rows in your dataset, which are specified by the conditional in the row expression. All other rows are removed from the dataset. 

The keep transform is the opposite of the delete transform. See Delete Transform.

keep row:(customerStatus == 'active')

Output: For each row in the dataset, if the value of the customerStatus column is active, then the row is retained. Otherwise, the row is deleted from the dataset.

keep row:(expression)

TokenRequired?Data TypeDescription
keepYtransformName of the transform
rowYstringExpression identifying the row or rows to keep. If expression evaluates to true for a row, the row is retained.


For the keep transform, if the expression for the row parameter evaluates to true for a row, it is kept in the dataset. Otherwise, it is removed.


keep row: (lastOrder >= 10000 && status == 'Active')

Output: Retains all rows in the dataset where the lastOrder value is greater than or equal to 10,000 and the customer status is Active

Required?Data Type
YesExpression that evaluates to true or false

Example - Remove old products and keep new orders