topic Re: not as it is data inserted into csv to mysql database in Talend Studio

not as it is data inserted into csv to mysql database

Anonymous — Sat, 16 Nov 2024 08:08:43 GMT

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

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

TRF — Wed, 06 Jun 2018 20:12:16 GMT

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?

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

Anonymous — Thu, 07 Jun 2018 08:10:48 GMT

Textract delimited