topic How to convert List<Dynamic> to Row with Dynamic Schema? in Talend Studio

How to convert List to Row with Dynamic Schema?

laughsmile — Thu, 16 Jan 2025 08:15:58 GMT

Hello everyone.

I have a List<Dynamic> variable stored in a Talend Context variable. How can I convert the Dynamic value of this variable to a Row in the dynamic schema?

I have tried tFixedFlowInput and tIterateToFlow components, but these component do not support Dynamic schema.

Thanks in advance

Ryu

Re: How to convert List to Row with Dynamic Schema?

Dave_Simo — Thu, 16 Jan 2025 15:32:24 GMT

Hello @laughsmile ,

Do you have an example of the expected result so that I can better visualize what you want to do?

Best Regards

Re: How to convert List to Row with Dynamic Schema?

laughsmile — Wed, 22 Jan 2025 01:56:05 GMT

Hello @Dave_Simo

Thanks for your response.

I have a Talend parent job and child job and running child jobs through a parent job.

Parent Job:

Reads a file with a dynamic schema.
Saves the content as List<Dynamic> in a context variable.

Child Job:

Reads another file with the same dynamic schema as the file in the parent job.

I want to Combines the data from the List<Dynamic> (passed from the parent job via context) with the data from the file read in the child job using a tUnite component.

Ryu

Re: How to convert List to Row with Dynamic Schema?

Dave_Simo — Wed, 22 Jan 2025 10:47:45 GMT

Hello,

I think I understand a little of what you want to do and it looks like what is done in the link below, maybe it will help you.

https://www.linkedin.com/pulse/dynamic-schema-talend-jean-francois-monteil-piose/?trackingId=C0kgOKVkTnG9mFcVWMJ%2FAQ%3D%3D

Best Reagrds

Re: How to convert List to Row with Dynamic Schema?

laughsmile — Fri, 07 Feb 2025 02:32:02 GMT

solve this problem by using tBufferOutput and tBufferInput.