DSXchange

Thanks for reading !

It is still a null handling question, my case as below.

Input : FieldA, FieldB
Output: FieldC

In transformer stage, derivation within FieldC

If IsNotNull(FieldA) Then
FieldA
Else
FieldB

As I know, there is handle_null() function within Modify stage.

FieldC = handle_null(FieldA, value)

here, it is only support value ? Can not be a field from input link ?

If yes, any other stage except transformer can fulfill my requirement.

Hi,
why not test it your self?

why dont u test like this
If Not(IsNull(FieldA)) Then
FieldA
Else
FieldB
[/quote]

Benny,

Are you sure a Null is there or Space ? For both of them you can use the following code,

If (IsNull(X) = 1 Or Trim(X) = "") Then <Action1> Else <Action2>

To check whether Null is coming or not you can use a Peek stage .

Regards
~Amitava