Derivation in the transformer.

[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.

[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 '/')