Transformer Constraint

devidotcom · Post by **devidotcom** » Sat Aug 17, 2013 5:34 am

Hi,

I have the below conditions inorder to filter records using the transformer stage. This works fine in Development environment of 8.7 but fails in Test 8.7 environment.

Stage Variable -
svFLAG ---> If NullToEmpty(ERR_IND) = 'Y' then 'ERR' Else 'T'

The transformer has 2 links as output -
First link constraint -
svFLAG = 'ERR' OR lnk_FROMLKP.FAILR_IND ='D'

Second link constraint -
svFLAG='T' AND lnk_FROMLKP.FAILR_IND <> 'D'

In the dev environment all 44 records flow to the first link. With the same source file in the test environment only 12 flow to the first link and 32 records flow to the second link.

I am not sure what are we missing.. the code comparison between projects shows there is no difference in the code. Could there be some environment variable not being set right? I don't see a difference there too.

Your help appreciated. Thanks.

chulett · Post by **chulett** » Sat Aug 17, 2013 7:31 am

What is different between the 12 & 32 records? Specifically, the values being checked - ERR_IND, FAILR_IND. I'm guessing your lookup source is different.