Issue with multiple IF's in a transformer derivation

[vskr72]

I am having issues with using multiple IF.THEN.ELSE conditions. Psl see below. I have 6 conditions to be tested in a single statement. I used a routing using a Begin..Case..END. Thsi worked good for few times. But all of a sudden the routine started giving errors in PROD server. When ever this happened, I had to promote the routine again. To prevent this in the future, I want to put it in a transformer derivation. When I put like this it gives me an error. Any help pls.

If (C_LINE=1) Then
'b'
if (C_LINE=2) then
'd'
end else
'f'
end
end


Thanks

Kumar

[us1aslam1us]

Kumar,

You need to do something like this:

"If condition1 then 'result1' elseif condition2 then 'result2' else 'result3'

[hsbc_ds_dev]

"If condition1 then 'result1' elseif condition2 then 'result2' else 'result3'

Should be...
If condition1 then 'result1' else if condition2 then 'result2' else 'result3'

[I_Server_Whale]

I used a routing using a Begin..Case..END. Thsi worked good for few times.

Routines are always (most of the time) a better way to code than using multiple If..Then...Else statements. Can you post the routine you created and the objective?

[narasimha]

But all of a sudden the routine started giving errors in PROD server. When ever this happened, I had to promote the routine again.

What errors did you get? You could try and debug that.

[kcbland]

Your syntax is wrong.

If (C_LINE=1) Then 'b' else if (C_LINE=2) then 'd' else 'f'

[ray.wurlod]

Your syntax is OK in a server routine, but not in an expression in a Transformer stage, which must be a single string.

There is never an End in a conditional expression.
There is no elseif statement in a conditional expression.

Your solution for an expression in a Transformer stage must be

Code: Select all

If (C_LINE=1) Then 'b' Else If (C_LINE=2) Then 'd' Else 'f' 

Note that "Else If" is two words. If you find it clearer, surround the nested conditional expression in unnecessary parentheses.

Code: Select all

If (C_LINE=1) Then 'b' Else (If (C_LINE=2) Then 'd' Else 'f')

[vskr72]

Ray,

Thanks a lot. It worked.

Kumar

[ray.wurlod]

So you can mark the thread as resolved.