Transformer derivation logic
Posted: Mon Jun 25, 2007 11:41 am
Hi All,
I have to populate to one of my target table column as per the below logic:
-populate "xxx"
-if value is not there for "xxx" then Populate "yyy"
-if value is not there for both "xxx" and "yyy" then populate "zzz"
-if value is not there for both "xxx" and "yyy" and "zzz" then leave blank.
So Itried with the below logic ,but it is not working as per the logic:
the derivation used in my transformer is :
If IsNotNull(xxx) Then Link.xxx
else If IsNotNull(YYY) Then Link.YYY
else If IsNotNull(ZZZ) Then ZZZ
Else ""
It is only populating the 'XXX' Value,but not populating as per the logic.
Could any one help me on my issue ,is there any thing missed in paranthesis or logic problem?
thanks in advance.
I have to populate to one of my target table column as per the below logic:
-populate "xxx"
-if value is not there for "xxx" then Populate "yyy"
-if value is not there for both "xxx" and "yyy" then populate "zzz"
-if value is not there for both "xxx" and "yyy" and "zzz" then leave blank.
So Itried with the below logic ,but it is not working as per the logic:
the derivation used in my transformer is :
If IsNotNull(xxx) Then Link.xxx
else If IsNotNull(YYY) Then Link.YYY
else If IsNotNull(ZZZ) Then ZZZ
Else ""
It is only populating the 'XXX' Value,but not populating as per the logic.
Could any one help me on my issue ,is there any thing missed in paranthesis or logic problem?
thanks in advance.