If value is negative need to make it default 0(zero)

[synsog]

Hi All,

Can we find whether the field is having Negative(-) value then I need to write default value zero(0).

Please advise any easy way for this.

Thanks in Advance

[jwiles]

Given the documented if-then-else construct in a transformer, how would you test for a negative value (that is, what would be the condition that determines whether or not the value is negative)?

Regards,

[peddakkagari]

IF Column_Value < 0 THEN 0 ELSE Column_Value

[selina_king]

both of peddakkagari and jwiles are right. but I have another idea to resolve the problem.

you can user transformer stage and use "null handing" function, you can set any value when is null

[chulett]

both of peddakkagari and jwiles are right. but I have another idea to resolve the problem.

you can user transformer stage and use "null handing" function, you can set any value when is null

Note, however, that nowhere in their problem statement is the word "null" mentioned.