MISSING DECIMAL VALUES after Talend outputs data from MySQL to Excel
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.