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