Skip to Content
DocumentationTransformsSet Value to Null

Set Value To Null

Edit Text

Sets the specified value in a column to null.

Examples

name

John Doe
Albert Fawn

Set to null

name

null
null

name

John Doe
Albert Fawn

Set to null


On:

Doe

name

null
Albert Fawn

Configuration

Column

Select the column(s) you want to edit.

On

Specifies a regex pattern that is used to conditionally replace the content of each column.

Choose from several predefined patterns or enter your own Regular Expression.

Where

Add a condition to specify when the transform should be applied. If this condition is not met for a row, the value in the selected column will remain unedited.

Screenshot of configuring the Edit text transform