String to Dynamic

One Star

String to Dynamic

How to convert string type to dynamic in EE ? if not is there any alternative solution available?
we are taking input as dynamic converting into string in tmap according to our requirement and want to convert back to dynamic.
Moderator

Re: String to Dynamic

Hi,
Do you want to use talend "Dynamic Schema" ?
Please see this KB article on talend help center How to process changing data structure
In addition, for file type, so far only tFileInputDelimited ? tFileInputPositional support for "Dynamic Schema".
You can go to this file: <Talend Studio install dir>/plugins/org.talend.core.tis_x.x.x.rxxxxx.jar. Unzip this jar to a directory, and you will see a file call supportDynamic.txt under resources folder, the file lists all the components support the dynamic schema in the current version.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: String to Dynamic

Yes we want to use dynamic schema but its not available in tsetdynamicschema in 5.02 EE?
Moderator

Re: String to Dynamic

Hi,
tSetDynamicschema is custom code component which is used to create a dynamic schema to allow components that are unable to guess the structure of the data being handled based on field separators, such as tFileInputPositional and tFileOutputPositional, to retrieve data from unknown columns.
Here is the scenario Handling a positional file based on a dynamic schema.
Usually, We often use "Dynamic Schema" for unknown schema structure, schema order and dynamic schema.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: String to Dynamic

Not sure why you need to convert dynamic into string and again to dynamic... if you are using this feature to replace values from incoming string then Dynamic schema may not be your best bet
One Star

Re: String to Dynamic

Hi Nishad ,
the incoming column is dynamic,we are using tostring() and using replace all () function to replace null to empty
and we want the same flow as dynamic.