Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilsh1
Contributor III
Contributor III

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.
Labels (2)
6 Replies
Anonymous
Not applicable

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
nikhilsh1
Contributor III
Contributor III
Author

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

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
Anonymous
Not applicable

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
nikhilsh1
Contributor III
Contributor III
Author

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.
kavita02
Contributor
Contributor

HI @nikhilsh , Please let me know if you got the solution, as I am also facing the same problem!!