Evaluating input columns

You want to evaluate each input row to see if certain conditions prevail.

You want to evaluate each input row to see if these conditions prevail:

  • EITHER all the following are true
    • Column number1 does not have the value 0
    • Column number2 does not have the value 3
    • Column number3 has the value 0
  • OR column name equals the string ZAG

You enter the following in the Where property:


number1 <> 0 and number2 <> 3 and number3 = 0 or name = 'ZAG'

If these conditions are met, the stage writes the row to the output link.