Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc
Excerpt

Deletes a set of rows in your dataset, based on a condition specified in the row expression. If the conditional expression is true, then the row is deleted. 

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

D s
snippetBasic

D code
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. 

D s
snippetParameters
D code

delete row:(expression)

TokenRequired?Data TypeDescription
deleteYtransformName of the transform
rowYstringExpression identifying the row or rows to delete. If expression evaluates to true for a row, the row is removed.  

D s lang notes

row

Include Page
row Parameter
row Parameter

Example:

D code

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

D s
snippetusage

Required?Data Type
YesExpression that evaluates to true or false


D s
snippetExamples

Example - Remove old products and keep new orders

Include Page
EXAMPLE - Delete and Keep Transforms
EXAMPLE - Delete and Keep Transforms

D s also
labelwrangle_transform_delete