topic MISSING DECIMAL VALUES after Talend outputs data from MySQL to Excel in Talend Studio

MISSING DECIMAL VALUES after Talend outputs data from MySQL to Excel

Anonymous — Sat, 16 Nov 2024 11:15:50 GMT

Hi everyone:
I am having an issue with outputting data from my MySQL database to an excel file. I notice that when Talend runs and uses the SQL query to extract the data from the database, it only shows integer values and not the whole number (including the digits to the right of the decimal).
I ran my MySQL command line terminal and it shows the decimal values just fine, so I am thinking there must be something going on with Talend. Can anyone tell me what I need to do for Talend to run the query and show the decimal values in the Excel output file.
The field variable is set to float(8,2) so it should the digits to the right of the decimal.

Thanks in advance everyone.

S. T.
PS: It also does the same thing when I have it output it to a CSV file also.
Someone please answer my post, this is for a project I am doing at work.
When I open up the file Talend creates it just gives me for example 1783439 instead of 1783439.95.
Thanks.

Re: MISSING DECIMAL VALUES after Talend outputs data from MySQL to Excel

Anonymous — Tue, 07 Apr 2015 19:23:49 GMT

Try using BigDecimal instead of Float.

Re: MISSING DECIMAL VALUES after Talend outputs data from MySQL to Excel

_AnonymousUser — Wed, 08 Apr 2015 13:34:11 GMT

Hi
I did try BigDecimal instead of float but the decimals still don't show up. What other options are there I can use?
S.T.

Re: MISSING DECIMAL VALUES after Talend outputs data from MySQL to Excel

Anonymous — Wed, 08 Apr 2015 14:07:40 GMT

hi,
did you fill length & precision to your decimal field (double or float) ?
ps : float & Double are loosing precision.
Only bigDecimal preserve precision.

no problem with my example !
regards
laurent

Re: MISSING DECIMAL VALUES after Talend outputs data from MySQL to Excel

Anonymous — Wed, 08 Apr 2015 21:14:50 GMT

I changed everything on the tMap and including in MySQL to BigDecimal and decimal() and I am still getting truncated values without any decimals.
What else can I do?

Re: MISSING DECIMAL VALUES after Talend outputs data from MySQL to Excel

Anonymous — Fri, 17 Apr 2015 15:45:02 GMT

thanks to post some screenshoot about your job to explore a little more your process and use of components .
regards
laurent