using a variable within if in script module

[#1]

Hi

I have a requirement wherein I need to perform an if else transformation within the edit script on certain condition based on a variable

But when I apply the if condition on the variable to create the field it is giving me an error

For Eg:

The if condition used is

If($(varb)=’ORACLE’,

If(flag=1,-1,

If(flag=0,0)),flag) as FLAG

The error that I see is Oracle not found.

Can any one please let me know what could the issue

[MK_QSL · Accepted solution]

Try

If('$(varb)'=’ORACLE’,

[#3]

Hi Anu,

Try the below one.

If('$(varb)'='ORACLE',

If(flag=1,-1,

If(flag=0,0)),flag) as FLAG

Hope this helps!

--

Vinoth