Version

    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

    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