topic Re: String to Dynamic Data Type in Talend Studio

String to Dynamic Data Type

karthikj18 — Wed, 23 May 2012 10:01:54 GMT

Hi,
I am using Talend Enterprise Edition of DI.
Can anyone know how to convert String data type to Dynamic Data Type in tMap?

Re: String to Dynamic Data Type

Anonymous — Wed, 23 May 2012 10:08:47 GMT

Hi
No. You can't simply covert data between String type and Dynamic type.
Dynamic is a feature called dynamic schema in Talend Enterprise Edition.
You can get instructions and scenarios from documents.
Regards,
Pedro

Re: String to Dynamic Data Type

karthikj18 — Wed, 23 May 2012 10:14:21 GMT

Hi Pedro,
There is issue in using the Dynamic data type.
The Dynamic data type fixes the First row's delimiter count as default and if the next records consist of more delimiters then its being truncated.
So I am trying to get the input from tFileInputFullRow as string and checking the row count and trying to convert as Dynamic.
There is also issue when try to convert Dynamic data type to string and getting the string count.(It gives different string count)
Is there any solution?

Re: String to Dynamic Data Type

Anonymous — Wed, 23 May 2012 10:19:58 GMT

Hi
If the schema of each row is different from others, you'd better read and loop this file only one row each time.
Regards,
Pedro

Re: String to Dynamic Data Type

karthikj18 — Wed, 23 May 2012 10:22:47 GMT

Hi,
I am trying to only allow the records if the delimiter count is matched.