Hi,
The single quote was missing, now the derivation is working fine. Thanks!!
Another doubt is regarding the expression
Code: Select all
If (DSLink3.Amount>0) Then (if Right(DSLink3.Amount,1)=3 Then Convert(Right(DSLink3.Amount,1),'A',DSLink3.Amount) Else DSLink3.Amount) Else "Negative"
I have to do the above check for each trailing character of every amont field in the table. I want to simplify the code so that if there is a change I need to change it in one place only.
I have 15 amount fields.
In server edition I could have used Transforms to break up the derivation and make it simpler.
e.g I could have one transform to get last digit of the amount
Another Transform to do the conversion and so on
But in parallel jobs we cannot use transforms
If I use stage variables I will again have 15 conditions for the 15 fields
Regards
Wah