Using NULL values in transformer constraints
Posted: Wed Aug 22, 2007 4:33 pm
Is it possible to exclude or include data within a transformer constraint based on if the field is NULL. Example below
isnull(FIELD1) or FIELD1>FIELD2 or FIELD1=FIELD2
in the transformer logic itself (not the constraint area) I can get around the nulls by saying something like if isnull(FIELD1) then setnull() else TRIM(FIELD1) i am hoping the transformer constraints do not have the same issue with NULL handling. Any FIELD1 that comes in as NULL from the lookup is thrown out because of the constraint. If I remove the constraint then the rows will be passed through.
Thanks
isnull(FIELD1) or FIELD1>FIELD2 or FIELD1=FIELD2
in the transformer logic itself (not the constraint area) I can get around the nulls by saying something like if isnull(FIELD1) then setnull() else TRIM(FIELD1) i am hoping the transformer constraints do not have the same issue with NULL handling. Any FIELD1 that comes in as NULL from the lookup is thrown out because of the constraint. If I remove the constraint then the rows will be passed through.
Thanks