1. Component library
  2. Transform
  3. Filter
  4. Compare

Compare

Compare two values using an operator of your choice. The options available in this filter resemble those of a SQL WHERE clause - you can specify columns, fixed values and use operators including the LIKE operator.

Filter Query optimizer Concurrent Distributed execution possible

Filter outcomes

  • TRUE

  • FALSE

Configured properties

  • Input column

    The column to compare values of

    InputColumn<Object> Required

  • Operator

    Choice: Less than Less than or equal Equal Like In Not equal Greater than or equal Greater than Required

  • Compare value

    Value to compare with

    String Optional

  • Compare column

    Column holding value to compare with

    InputColumn<Object> Optional