Null To Value not found

[pradkumar]

Hi

When I searched in DS help, I found a Null to Value, Null to Empty functions. But when I opened my transformer and chekced in DS Transforms under built in under Null, I found only Null To Empty.
I donot see Null to Vlaue.
Why this is happening so?

Thanks

[ArndW]

Look for NullToValue in the null handling tab of functions, you will find it there.

[pradkumar]

In the DS Transform, I am having only Builtin->Null->Null to Empty, Null to Zero.

In Null Handling, I am having only IsNull function but not Null to Value

Thanks
Sunil

[ArndW]

I'm not at DS to confirm that. Why not bypass this problem and use a derivation of "IF IsNull(In.Column) THEN 'Value' ELSE In.Column"?

[sud]

I'm not at DS to confirm that. Why not bypass this problem and use a derivation of "IF IsNull(In.Column) THEN 'Value' ELSE In.Column"?

Yep since Nulltovalue is only in parallel jobs.

[pradkumar]

Yes, I can use it. The thing I am unable to understand is why few functions are visible and few of them are not. Do we need to install any plug ins?

[sud]

Yes, I can use it. The thing I am unable to understand is why few functions are visible and few of them are not. Do we need to install any plug ins?

No, actually some functions are there in parallel and some in server and, the nulltovalue function is not there in server. There is no additional installation needed, this function is just not there for server jobs. So either you can write your own Basic routine or use Arnd's suggestion.

[dspxlearn]

pradkumar,

By looking into your first post, it seems that when you searched the DShelp, you might have found the those functions on the parallel pages but not on the server.
Thats why when you open a transformer they are all missing.

[ray.wurlod]

Copy the NullToZero transform and make your own NullToValue. It takes less than two minutes.