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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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