![remove rows with errors example source](../figures/remove-rows-with-errors-example-source.png)
Remove rows with errors
The Remove rows with errors step removes all rows that have error in the specified column or columns.
Parameters
-
Error position: required, select where to look for errors:
-
in any column: consider all columns from the whole data set and remove rows that contain errors in any column.
-
in selected column: only consider selected column and remove rows that contain error in that column only.
-
Example
Consider a data set like the one below where we have payments data and we were unable to convert $orderId
column to integer. This means that we would not be able to join the data with order data and then further with customer data.
![remove rows with errors example source](../figures/remove-rows-with-errors-example-source.png)
To avoid transforming rows that cannot be used, we can easily remove them all from the process by using Remove rows with errors configured to look into $orderId
column. The output will then look like this:
![remove rows with errors example result](../figures/remove-rows-with-errors-example-result.png)