Constraint issue

[myukassign]

I have an interesting issue which i am not able to find a solution. Any help will be greatly helpful to me.

In the transformer constraint, i want to add two condition to reject rows from a particular link.

Not( sfpri_Bunit.GROUP_CODE MATCHES "..") Or Not(Left(sfpri_Bunit.GROUP_CODE,2) MATCHES " ")

See this is the condition above. The ineresting part is if I give only one condition (either of the above) at a time, the rows are rejecting but when I give in the combined form above, no rows are rejecting. If it is an orconditon it should work nicly. Ideally two rows shold be rejected but not happening.

Can anyone through some light in fixign this issue?

[ray.wurlod]

Neither right operand of the MATCHES operator includes any wildcard characters. Are you interested in doing an "equals" comparison or a "contains" comparison? The equals comparison is straightforward - simply replace the MATCHES operators with "=" operators. The contains comparison requires you to extend your right-hand operands to include wildcard characters ("..." or "0X").
The other problem you have is that an expression of the form Not(X) Or Not(Y) is always true (provided that X and Y are different). You probably need an And operator here. Assuming that is the case, the following expression should get you close

Code: Select all

Not(sfpri_Bunit.GROUP_CODE MATCHES "0X'..'0X") And Not(Left(sfpri_Bunit.GROUP_CODE,2) MATCHES "0X' '0X") 

[myukassign]

Right on target!!

Thank you so much for the reply.....

it was a near logic problem, the minue i removed "OR" with "AND"

I got my buggy run right

Thanks I am closing this issue.