DSXchange

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

Where is the else part for your last if statement?

Thanks Vivekananda, I got it and it is working fine

Regards

Srini

What happens when you right-click on the expression and choose "Validate" from the menu?