Page 1 of 1

Derivation in the transformer.

Posted: Tue Aug 10, 2010 7:29 am
by kollurianu
Hi All ,

I am trying the below derivation in transformer, but it is not working as expected.

Ie; on DEV/TEST environment , it should be as "Z-EQUITY" but it is giving as "EQUITY"

And "SrcFileDir" is a job parameter.

SrcFileDir = /data/edapd/ascential/file/BrsReImpl1Dev/src/


If ((Field(SrcFileDir,"/", 2) = "edapd') Or (Field(SrcFileDir,"/", 2) = 'edapm')) Then "Z-EQUITY" Else "EQUITY"

Appreciate your help in advance.

Posted: Tue Aug 10, 2010 7:31 am
by ArndW

Code: Select all

If ((Field(SrcFileDir,"/", 3) = "edapd') Or (Field(SrcFileDir,"/", 3) = 'edapm')) Then "Z-EQUITY" Else "EQUITY" 
The first field in your string is "" empty (left of the first '/')