Retains a set of rows in your dataset, which are specified by the conditional in 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||Y||transform||Name of the transform|
|row||Y||string||Expression identifying the row or rows to keep. If expression evaluates to |
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
|Yes||Expression that evaluates to |