General functions

Clear cells

Clears the content of all the cells in the column. The resulting cells will contain null values.

Properties

Property	Configuration
Columns to process	Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply.
Create new column	Select this check box if you want to output the result of this function in a new column and keep the original untouched.

Property

Configuration

Columns to process

Select the column or columns on which you want to apply the function.

If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply.

Create new column

Select this check box if you want to output the result of this function in a new column and keep the original untouched.

Example

Input	Output
09/05/1969 12/10/2021	Null Null

Delete filtered rows

Deletes all the rows that match the filter currently applied on the table.

Properties

There are no specific properties to configure for this function. Select the function in the functions list and click Apply.

The filter is automatically cleared once the function is applied.

Fill cells

Fills cells with a constant value or values from another column.

Properties

Property	Configuration
Columns to process	Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply.
Use with	Value: Select this option to fill the column with a fixed value, set in the Value field. Other column: Select this option to fill the column with values from another column, set in the Column drop-down list.

Property

Configuration

Columns to process

Select the column or columns on which you want to apply the function.

If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply.

Use with

Value: Select this option to fill the column with a fixed value, set in the Value field.
Other column: Select this option to fill the column with values from another column, set in the Column drop-down list.

Example

Input	Configuration	Output
09/05/1969 Null 75000	Use with: Value Value: Recipe	Recipe Recipe Recipe Recipe

Fill null and empty cells

Fills both null and empty cells with a constant value or values from another column.

Properties

Property	Configuration
Columns to process	Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply.
Use with	Value: Select this option to fill the column with a fixed value, set in the Value field. Other column: Select this option to fill the column with values from another column, set in the Column drop-down list.

Property

Configuration

Columns to process

Select the column or columns on which you want to apply the function.

If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply.

Use with

Value: Select this option to fill the column with a fixed value, set in the Value field.
Other column: Select this option to fill the column with values from another column, set in the Column drop-down list.

Alternatively, you can use this function by right-clicking a null or empty cell in the table and selecting the Fill null and empty cells option. A recipe step then opens where you can enter the new value to use. Finish the step configuration and click Apply.

Example

Input	Configuration	Output
09/05/1969 Null 75000	Use with: Value Value: Recipe	09/05/1969 Recipe Recipe 75000

Keep filtered rows

Properties

Keeps all the rows that match the filter currently applied on the table by deleting all the non matching rows.

Properties

There are no specific properties to configure for this function. Select the function in the functions list and click Apply.

The filter is automatically cleared once the function is applied.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here