Join stage error

[wfis]

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

[samsuf2002]

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)

[wfis]

The datatype specified for Value1 and Value2 was notcorrect.Resolved the issue.