topic [resolved] How to set Float default values in the schema. in Talend Studio

[resolved] How to set Float default values in the schema.

karthik_koneru — Wed, 18 Nov 2015 18:58:11 GMT

Hi Frds,
How to set default Float values in the schema of tOracleOutput component to replace null values retrieved from the data source.
I have tried for Integer and String, it is working fine.
FYI,
https://help.talend.com/search/all?query=How+to+set+default+values+in+the+schema+of+an+component&content-lang=en
But unable to set for Float data type.
Can someone suggest me how to do it.
Thanks
KK

Re: [resolved] How to set Float default values in the schema.

Anonymous — Thu, 19 Nov 2015 08:33:09 GMT

Hi,
At present, only tFileInputDelimited, tFileInputExcel, and tFixedFlowInput support default values in the schema.

Have you tried to use tFileInputDelimited to set float default vaules in the schema to see if it works?
Best regards
Sabrina

Re: [resolved] How to set Float default values in the schema.

karthik_koneru — Thu, 19 Nov 2015 14:16:20 GMT

I have tried tFileInputDelimited and it is working fine.
But I want this feature for tOracleOutput component,
where we need to Insert default values(like 0) for FLOAT column null values.
My question is why it didn't work with tOracleOutput Component?
Thanks
KK

Re: [resolved] How to set Float default values in the schema.

karthik_koneru — Thu, 19 Nov 2015 14:56:54 GMT

Hi Sabrina,
I have found this for tOracleInput and tOracleOutput Components.
https://help.talend.com/search/all?query=Verifying+default+values+in+a+retrieved+schema&content-lang=en

Re: [resolved] How to set Float default values in the schema.

Anonymous — Fri, 20 Nov 2015 04:23:42 GMT

Hi kk,
Thanks for your feedback. Have you already checked the workaround provided by shong?

As a workaround, you can convert the null value to a default Float value on a tMap before tOracleOutput. For example:
tFileInputDelimited--row1--tMap--out1–tOracleOutput
write the following expression for the column of output table:
row1.c1==null ||row1.c1.equals("")?10.1f:row1.c1

"
Best regards
Sabrina

Re: [resolved] How to set Float default values in the schema.

karthik_koneru — Mon, 23 Nov 2015 16:28:48 GMT

Thanks Sabrina,
But I have found another way to do it.
Now it is working for tOracleOutput component. I have used SQL DEFAULT Constraint.
Thanks
KK

Re: [resolved] How to set Float default values in the schema.

Anonymous — Tue, 24 Nov 2015 03:08:32 GMT

Hi,

I have used SQL DEFAULT Constraint.

Would you mind sharing your solution with us? Screenshots will be highly appreciated.

Best regards
Sabrina

Re: [resolved] How to set Float default values in the schema.

karthik_koneru — Wed, 02 Dec 2015 18:31:23 GMT

Sorry for late response.
Thanks
KK

Re: [resolved] How to set Float default values in the schema.

Anonymous — Thu, 16 Jan 2020 13:10:16 GMT

Thanks so much for the solution !