# General functions

## Cleanse

Replace invalid, empty, or null values of a column with specific values.

### Properties

| Property | Configuration |
| --- | --- |
| Columns to process | Select the column or columns on which you want to apply the function.<br><br>If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Replace | Select the type of values to target and replace. You can use the function to target any of the following:<br><br><ul> <li> <p><span>Invalid</span> </p> </li> <li> <p><span>Null</span> </p> </li> <li> <p><span>Empty</span> </p> </li> </ul> |
| Use with | <ul> <li> <p><span>Value</span>: Select this option to fill the column with a fixed value, set in the <span>Value</span> field.</p> </li> <li> <p><span>Other column</span>: Select this option to fill the column with values from another column, set in the <span>Column</span> drop-down list.</p> </li> <li> <p><span>Null</span>: Select this option to fill the targeted cells with null values.</p> </li> </ul> |

Tip noteAlternatively, 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 |
| --- | --- | --- |
| <ul> <li> <p>09/05/1969</p> </li> <li> <p>Null</p> </li> <li> <p>&nbsp;</p> </li> <li> <p>75000</p> </li> </ul> | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value: Recipe</p> </li> </ul> | <ul> <li> <p>09/05/1969</p> </li> <li> <p>Recipe</p> </li> <li> <p>Recipe</p> </li> <li> <p>75000</p> </li> </ul> |

## 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.<br><br>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 |
| --- | --- |
| <ul> <li> <p>09/05/1969</p> </li> <li> <p>12/10/2021</p> </li> </ul> | <ul> <li> <p>Null</p> </li> <li> <p>Null</p> </li> </ul> |

## 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.<br><br>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 | <ul> <li> <p><span>Value</span>: Select this option to fill the column with a fixed value, set in the <span>Value</span> field.</p> </li> <li> <p><span>Other column</span>: Select this option to fill the column with values from another column, set in the <span>Column</span> drop-down list.</p> </li> </ul> |

### Example

| Input | Configuration | Output |
| --- | --- | --- |
| <ul> <li> <p>09/05/1969</p> </li> <li> <p>Null</p> </li> <li> <p>&nbsp;</p> </li> <li> <p>75000</p> </li> </ul> | <ul> <li> <p>Use with: Value</p> </li> <li> <p>Value: Recipe</p> </li> </ul> | <ul> <li> <p>Recipe</p> </li> <li> <p>Recipe</p> </li> <li> <p>Recipe</p> </li> <li> <p>Recipe</p> </li> </ul> |

## 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.