I´m facing a problem in my kettle extract.... I´m extracting values from a MySql database. 1 of the fields is a float. The problem is that wen i use kettle to extract data from the original database, but wen i take a float like 2.5, it only place the value 2 on the target table. Both fields are float, and kettle recognize the 2.5 value as 2,5. The swap from "." to "," bring problems with the data too.
Can someone help plz?
How can i extract a float value from a mysql table and place it in another mysql table, without swapping 2.5 to 2,5?