topic Re: Numeric field getting converted to string for dynamic datatype for csv file in Talend Studio

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

Anonymous — Mon, 24 Apr 2017 11:04:43 GMT

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

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

Sid3 — Mon, 24 Apr 2017 12:11:22 GMT

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.

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

Anonymous — Tue, 25 Apr 2017 09:40:54 GMT

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.