DSXchange

All,

I think there is some limitation to do comparison as below in the transformer stage column derivation.

seqfile ----------> transformer -----------> seqfile
DSLink1 DSLink2

In transformer stage,

If DSLink1.DTLRowCont = DSLink1.TRLRowCnt then 'FOOTER RECORD COUNT IS MATCHING WITH DETAIL SECTION' ELSE 'RECORD COUNT MISMATCH'

If I use the above IF statement in the column derivation, it is showing in the red color.

If I use the same in stage variable, it is working fine.

StageVar = If DSLink1.DTLRowCont = DSLink1.TRLRowCnt then 'FOOTER RECORD COUNT IS MATCHING WITH DETAIL SECTION' ELSE 'RECORD COUNT MISMATCH'

Created a link between StageVar to Transformer column.

I am able to see the proper message. How?

Is it some limitation of column derivation?

Red can be like a warning. With the derivation as red in the Transformer stage, can you compile it, run it, and still get the correct result? Sometimes that is the case.

I'm not seeing that behavior on 11.3. What version are you on?

Right click on the red expression and choose "Validate Derivation" from the menu; the expression editor will tell you what it thinks is wrong with the syntax - for example field and link names are case sensitive. Maybe you mis-spelled "Count" as "Cont".