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.