DSXchange

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

We had a Similar issue and the workaround was splitting the ISNotNull and Comparison clause

Nutshell

If IsNotNull(Y)
Then
If (Y<>0)
<case1>
Else
<case2>
Else
<case1>

rhaddur wrote:Constraint

(x <> "ZZZB" And )
(
((IsNotNull(Y)) AND (Y<>0))
Or ((IsNotNull(z)) AND (z<>0))
Or ((zz)) AND (zz<>0))
)

Your code looks all over the place. Can you please copy the exact from your transformer?

Here's a crazy thought - why not explain to us in words what this is supposed to accomplish and then let us know what's not "working properly" about it?