BS Filter Row Data Flow Transformation to skip Rows

This transformation allows to skip rows and prevents them from being imported or updated. You can find it as “BS Filter Row” transformation and configure three settings to define positive or negative filter definitions:

  • Filter Condition: multiple logical operators

  • Filter Value: to enter a value for the condition

  • Filter Action: to define, if rows should be in- or excluded when the filter condition is fulfilled.

Make sure to sort such filter definitions up in the sequence of transformations, to make sure, that no other transformation modifies data by side effects, e.g. a Hierarchy rule creating folders for rows, that later should not even be imported.