In the Transformer I need to use below logic. For ADDRESS field derivation
When I am using below syntax it is througing error (RED colour) in the Transformer
Can any one Please correct the below syntax
if INPUT_Link.Field_NM_LNS =1 then INPUT_Link.LN_1_TX :' ': INPUT_Lin.LN_2_TX :' ': INPUT_Lin.LN_3_TX :' ': INPUT_Lin.LN_4_TX :' '
: INPUT_Lin.LN_5_TX :' ': INPUT_Lin.LN_6_TX
else ( if INPUT_Lin.Field_NM_LNS =2 then
INPUT_Link.LN_3_TX :' ': INPUT_Link.LN_4_TX :' ': INPUT_Link.LN_5_TX :' ': INPUT_Link.LN_6_TX
else(if INPUT_Link.Field_NM_LNS =3 then
INPUT_Link.LN_4_TX :' ': INPUT_Link.LN_5_TX :' ': INPUT_Link.LN_6_TX
else(if INPUT_Link.Field_NM_LNS =4 then
INPUT_Link.LN_5_TX :' ': INPUT_Link.LN_6_TX
else(if INPUT_Link.Field_NM_LNS =5 then INPUT_Link.LN_6_TX
)
)
)
)
INPUT_Link -- Input Link name
Field_NM_LNS Input field name
LN_1_TX Input field names
I am waiting for your solution
Thanks
srini
Transformer derivation syntax is need for my requirement
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
Where is the else part for your last if statement?
Code: Select all
if INPUT_Link.Field_NM_LNS =5 then INPUT_Link.LN_6_TX
You are the creator of your destiny - Swami Vivekananda
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
Thank yu very much Vivekananda
Thanks Vivekananda, I got it and it is working fine
Regards
Srini
Regards
Srini
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: