In Transformer Stage following the constraint not working Properly
Here
x is varchar
y, z, zz are decimal
Constraint
(x <> "ZZZB" And )
(
((IsNotNull(Y)) AND (Y<>0))
Or ((IsNotNull(z)) AND (z<>0))
Or ((zz)) AND (zz<>0))
)
But Working in Filter Stage
Condition
(x<>'ZZZB' AND
(
((Y Is Not Null) AND (Y<>0))
Or ((z Is Not Null) AND (z<>0))
Or ((zz Is Not Null) AND (zz <>0))))
Kindly let me know what could be the reason it is not working Properly in Transformer Stage
The constraing is not working properly in Transformer but wo
Moderators: chulett, rschirm, roy
Re: The constraing is not working properly in Transformer bu
Your code looks all over the place. Can you please copy the exact from your transformer?rhaddur wrote:Constraint
(x <> "ZZZB" And )
(
((IsNotNull(Y)) AND (Y<>0))
Or ((IsNotNull(z)) AND (z<>0))
Or ((zz)) AND (zz<>0))
)
gateleys