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.
Transformer derivation logic
Moderators: chulett, rschirm, roy
Transformer derivation logic
Thanx&Regards
scorpion
scorpion
-
- Charter Member
- Posts: 64
- Joined: Sat Sep 17, 2005 10:42 am
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Re: Transformer derivation logic
If this is the exact code you are using then it is wrong.scorpion wrote:If IsNotNull(xxx) Then Link.xxx
else If IsNotNull(YYY) Then Link.YYY
else If IsNotNull(ZZZ) Then ZZZ
Else ""
It should have been
Code: Select all
If IsNotNull(Link.xxx) Then Link.xxx
else If IsNotNull(Link.YYY) Then Link.YYY
else If IsNotNull(Link.ZZZ) Then Link.ZZZ
Else ""
IsNull(Link.xxx)=0 instead of IsNotNull(Link.xxx).............
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
Thanks to all,
I got the solution,i removed NullToEmpty and Trim function in the earlier transformer stage and i applied
If IsNotNull(Link.xxx) Then Link.xxx
else If IsNotNull(Link.YYY) Then Link.YYY
else If IsNotNull(Link.ZZZ) Then Link.ZZZ
Else ""
it is working fine.
thanks for the help all.
I got the solution,i removed NullToEmpty and Trim function in the earlier transformer stage and i applied
If IsNotNull(Link.xxx) Then Link.xxx
else If IsNotNull(Link.YYY) Then Link.YYY
else If IsNotNull(Link.ZZZ) Then Link.ZZZ
Else ""
it is working fine.
thanks for the help all.
Thanx&Regards
scorpion
scorpion