Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Labels (4)
2 Replies
TRF
Champion II
Champion II

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?
Anonymous
Not applicable
Author

Textract delimited