trouble reading negative values from CSV files

Anonymous — Sat, 16 Nov 2024 04:37:17 GMT

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

Re: trouble reading negative values from CSV files

vapukov — Mon, 30 Sep 2019 08:55:25 GMT

I think your problem just from thousands separator, you need to define it in the studio, on Advanced setting of tFileInputDelimited component

topic trouble reading negative values from CSV files in Data Quality

trouble reading negative values from CSV files

Re: trouble reading negative values from CSV files