Skip to Content
DocumentationTransformsDelete

Delete Rows

Removes all rows that match a given filter.

Example

timestampcity
1247418467London

1362374551

Paris
1341277810London
1343896726London

1427235149

Paris

where:

city = ‘Paris’

timestampcity
1247418467London
1341277810London
1343896726London

Configuration

The following filter syntax is used when configuring the Where condition input.

Text matching:
  • COLUMN contains ‘event’
  • COLUMN does not contain ‘event’
  • COLUMN starts with ‘a’
  • COLUMN does not start with ‘a’
Regular Expressions:
  • COLUMN matches ’.*event$’
  • COLUMN does not match ’.*event$‘
Order Matching:
  • COLUMN < 42
  • COLUMN >= ‘2015-01-01’
  • COLUMN < ‘2015-01-01 12:34:56.000’
Type Matching:
  • COLUMN is an integer
  • COLUMN is not a date
Equality:
  • COLUMN = ‘expired’
  • COLUMN = 35
  • COLUMN != 35
Empty Checking:
  • row is empty
  • COLUMN is empty
  • COLUMN is not empty
Comparisons with another Column:
  • COLUMN1 > COLUMN2
  • COLUMN1 contains COLUMN2
  • etc. for any of the operators above
Conjunctions:
  • CONDITION1 and CONDITION2
Screenshot of delete transform configuration

Adding the Transform

  1. Select any row by clicking on its row number to left of the table.
  2. Find Delete transform under Row Manipulation group.

Alternatively, you can click on + Add Script Step on the right of the wrangler, type delete in the search input, or find Delete transform under Row Manipulation group.

screen recording of adding the delete transform

Key Considerations

Both null and empty strings are considered empty in the filter.

DecodeDrop