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

2 REPLIES
Forteen Stars TRF
Forteen 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