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.
String Concatenation
Moderators: chulett, rschirm, roy
String Concatenation
Aim high
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
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'