Numeric field getting converted to string for dynamic datatype for csv file

[Anonymous]

Hi All,

I have a talend job which reads from  a .csv file and writes to a greenplum table using the "dynamic column" feature of Talend Enterprise Edition. Its a simple one to one mapping job.

The table structure is already defined and a few numeric/date fields are present. 

Problem is dynamic data type is reading all fields as string and job is erroring out saying Column is of type numeric but expression is of string.

Can anyone help me in modifying the settings for dynamic datatype to detect numeric and date fields automatically.

Regards,

Rashmitha.B

[Sid3]

Yes, Dynamic schema reads all fields String data type you need to transform the data(using TMAP) before you send it to your target.

Thanks,
Sid
Please like the post if it is useful
Please put to resolved if it resolves your issue.

[Anonymous]

Thanks for your reply.

The reason why we chose Dynamic datatype was because we do not know the column names and their datatypes. The same job has to run for multiple files. 

Can you give me an example of how  to convert in tmap? I have only one column of datatype Dynamic.