Hello OR logic in transformer Stage

[sushanth]

Hai I need to change derivations in Transformer stage from OR logic to IF then Else if ,for the following Logic help
If IsNull(Tocl1) Or Len(Tocol1) = 0 Then 'sample' Else To col1



Yours

[sanjay]

if IsNull(Tocl1) Then 0 else if
Len(Tocol1) = 0 Then 0 else
col1

Thanks

Hai I need to change derivations in Transformer stage from OR logic to IF then Else if ,for the following Logic help
If IsNull(Tocl1) Or Len(Tocol1) = 0 Then 'sample' Else To col1



Yours

[richdhan]

Hi Sushanth,

Just go ahead and change the derivation using the expression editor. If something is wrong it will appear in RED. Whatever logic you would like to apply just put it in the derivation using the expression editor. It should work.

HTH
--Rich

Pride comes before a fall
Humility comes before honour

[ray.wurlod]

Hai I need to change derivations in Transformer stage from OR logic to IF then Else if ,for the following Logic help
If IsNull(Tocl1) Or Len(Tocol1) = 0 Then 'sample' Else Tocol1

Why do you need to change? The logic you have will work perfectly well.

[sandy]

Hi,

OR logic is not working as expected in the transformer and hence recently even we had to change all the OR conditions to If Then Else in the transformers. I think Sushant is also a victim of this issue.

Thanks

[ray.wurlod]

The site I'm on at present isn't using PX, so I can't verify your claim. I trust you've reported it to Ascential?

[vmcburney]

What you have is the old Oracle NVL function, if a value is empty or null replace it with a given value, else leave it alone. Why not write your own routine to do this which is passed the field value and the replacement value. In a routine you can use the Test button to make sure your code works and then use it in all your jobs. When you want to change it you only need to change it in one place and you do not need to recompile any jobs.

[sushanth]

Hi,

Yah you got it It happened like that
Thanks