Using components: Filter Transformation

Use the Filter transformation to filter input data by defining conditions that must be met by records in the input.

Conditions

Logical operator

By default, a record must match all the conditions.

  • Match all of the following conditions (AND) - selects records with values that meet all conditions specified (logical "AND")
  • Match any of the following conditions (OR) - selects records with values that meet at least one of the conditions specified (logical "OR")
  • Match none of the following conditions (NOT) - selects records with values that doesn't meet any of the conditions specified (NOT ( OR ))
  • Specifying conditions

    Each condition is comprised of an expression (or field), an comparison operator and possibly another value or expression to compare with (depending on the operator).

    • Expression (left-hand) - In the drop-down list on the left, select a field or edit an expression.
      Read more about expressions and functions).
    • Operator - select the operator from the following list:
      Operator Description
      text equals The expression on the left must be equal to the string value on the right. The text should not be enclosed in quotes or escaped.
      text not equals The expression on the left must not be equal to the string value on the right. The text should not be enclosed in quotes or escaped.
      text matches The expression on the left must must match the regular expression string value on the right. The text should not be enclosed in quotes or escaped. For example, matching a string field with .*dog.* would pass any string that contains the string dog: dog,dogs,adogmatic
      text is empty The expression on the left must be empty.
      text is not empty The expression on the left must not be empty.
      = The expression on the left must be equal to the expression on the right.
      != The expression on the left must not be equal to the expression on the right.
      > The expression on the left must be greater than the expression on the right.
      >= The expression on the left must be greater than or equal to the expression on the right.
      < The expression on the left must be less than the expression on the right.
      <= The expression on the left must be less than or equal to the expression on the right.
      is null The expression on the left must be null.
      is not null The expression on the left must not be null.
      is true The expression on the left must true - especially useful when left hand side is a complex expression.
    • Value/Expression - with text operators, type the text or pattern to compare to. With other operators, pick a field or edit an expression.

    Creating packages

    1. Creating a new package in New Xplenty
    2. Creating a workflow
    3. Working in the new package designer
    4. Validating a package
    5. Using components: Amazon Redshift Source
    6. Using components: Bing Ads Source
    7. Using components: Database Source
    8. Using components: Facebook Ads Insights Source
    9. Using components: File Storage Source
    10. Using components: Google Adwords source
    11. Using components: Google Analytics Source
    12. Using components: Google BigQuery Source
    13. Using components: Google Cloud Spanner Source
    14. Using components: MongoDB Source
    15. Using components: NetSuite Source
    16. Using components: Salesforce source
    17. Using components: Rest API Source
    18. Using components: Aggregate Transformation
    19. Using components: Assert Transformation
    20. Using components: Clone transformation
    21. Using components: Cross Join Transformation
    22. Using components: Distinct Transformation
    23. Using components: Filter Transformation
    24. Using components: Join Transformation
    25. Using components: Limit Transformation
    26. Using components: Rank Transformation
    27. Using components: Select Transformation
    28. Using components: Sort Transformation
    29. Using components: Union Transformation
    30. Using components: Window Transformation
    31. Using components: Sample Transformation
    32. Using components: Cube transformation
    33. Using components: Amazon Redshift Destination
    34. Using components: Database Destination
    35. Using components: File Storage Destination
    36. Using components: Google BigQuery Destination
    37. Using components: Google Spanner Destination
    38. Using components: MongoDB Destination
    39. Using components: Salesforce Destination
    40. Using components: Snowflake Destination (beta)
    41. Using and setting variables in your packages
    42. System and pre-defined variables
    43. Using pattern-matching in source component paths
    44. Using ISO 8601 string functions
    45. Using Expressions in Xplenty
    46. Xplenty Functions

    Feedback and Knowledge Base