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.
Null handling
Moderators: chulett, rschirm, roy
Hi,
why not test it your self?
why not test it your self?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Re: Null handling
why dont u test like this
If Not(IsNull(FieldA)) Then
FieldA
Else
FieldB
[/quote]
If Not(IsNull(FieldA)) Then
FieldA
Else
FieldB
[/quote]
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact: