Hello,
I'm trying to load an Input CSV file into Mysql DB with two fields having numeric values. When I read the CSV file into Talend, negative values under one field are being read in brackets for eg: -100.00 as (100.00) whereas for the other field it doesn't do the same eg: -5.00 is being read as -5.00.
So, in Tmap when I'm forcing these string columns to convert into float values...it's not working as they have special characters.
How do I read negative values into my database so that later when I group the numeric column by a particular dimension it has to take a sum of -ve & +ve values?
I'm thinking of using tReplace to replace "(" with "-" and ")" with "". Yet I'm not sure if I'd be able to convert "-644.00" to float datatype as it'll be still having "-" as a special character.
Below I'm attaching screenshots of my tmap, job design, and input schema.
Thanks and regards,
Praneeth Reddy Varimalla
