Hi All,
I am performing a left outer join with 3 links.
Link 1 --- left link
Link 2 --- intermediate link
Link 3 -- right link
The left link has the following combination
Col A Col B
a b
c d
Intermediate link
Col A Col B Value1
a b 1
Rigt Link
Col A Col B Value2
c d 2
a b 2
Output Required is
Col A Col B Value1 Value2
a b 1 2
c d 0 2
The Value 1 and Value 2 columns are outputs of aggregator stage.
I get the following fatal error and following output.
Col A Col B Value1 Value2
a b Null Null
c d 0 Null
Error is
APT_CombinedOperatorController(1),3: Un-handled conversion error on field "Value1 " from source type "dfloat" to destination type "int32":
source value="73"; the result is non-nullable and there is no handle_null to specify a default value. [api/interface_rep.C:1972]
Please advice.
Thanks
Join stage error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
Make sure that the sql type for Value1 is same in the job and if you want it to be different then use appropriate function to convert it. Also you need to handle the null values for column Value1 by the following code in the transformer column derivation.
Code: Select all
If IsNull(trim(Value1)) then '' else trim(Value1)
hi sam here