not as it is data inserted into csv to mysql database

Five Stars

not as it is data inserted into csv to mysql database

dear all,

 

actually i wantto store csv file data into the mysql database table.the csv has two column name as  date and temp.temp datatype is float but when i run the job.in table showing different value.

 

eq.temp value in csv=3.00

     sql table value=2100.00

Fifteen Stars TRF
Fifteen Stars

Re: not as it is data inserted into csv to mysql database

How do you proceed to convert from String (your csv) to Float?
What between tFileInputDelimited and tMySQLOutput?
Any chance you have a trigger which change the value when the rows are Inserted/Updated i to the database?

TRF
Five Stars

Re: not as it is data inserted into csv to mysql database

Textract delimited

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads