String Concatenation

[nkln@you]

I am doing the follwoing derivation in Transformer.

If Write_Reversal.END_USER_NAME<> Read_SpaChannelHistory.END_USER_NAME Then 'AOO |' Else '' : '|' : If Write_Reversal.CHANNEL_FLAG<> Read_SpaChannelHistory.CHANNEL_FLAG Then 'CF' Else ''

While Testing the 1st If condition is true AND Second If Condition is True.

So, the output should be AOO|COO

But I am getting output as AOO|

If I give derivation as 'AOO |' : If Write_Reversal.CHANNEL_FLAG<> Read_SpaChannelHistory.CHANNEL_FLAG Then 'CF' Else ''

The output is coming as AOO|CF

What is wrong with my original derivation.

[paddu]

(If( Write_Reversal.END_USER_NAME<> Read_SpaChannelHistory.END_USER_NAME Then 'AOO |') Else '') : '|' : ( If (Write_Reversal.CHANNEL_FLAG<> Read_SpaChannelHistory.CHANNEL_FLAG Then 'CF' )Else '' )

try using this

[kumar_s]

Else to make it more clear assign each expression in individual Stage variable and concatinate the variables.

Code: Select all

vStageVar1 =? If Write_Reversal.END_USER_NAME<> Read_SpaChannelHistory.END_USER_NAME Then 'AOO |' Else ''

VStrageVar2 => If Write_Reversal.CHANNEL_FLAG<> Read_SpaChannelHistory.CHANNEL_FLAG Then 'CF' Else ''

Expression => vStageVar1:vStageVar2