topic Convert List<X> to excel output file in Talend Studio

Convert List to excel output file

heshkaru — Fri, 15 Nov 2024 22:49:13 GMT

Hi,

I have created a routine and generated a List<X> and it is working up to that place. Is there a way to iterate this list and add records to an output excel file.

Below is the list.

[OutputFile{jsonPath='jsonPath1', oldValue='val1', newValue='newVal', isMatching=false}, OutputFile{jsonPath='jsonPath2', oldValue='val2', newValue='newVal2', isMatching=false}]

Thank you

Re: Convert List to excel output file

gjeremy1617088143 — Fri, 17 Jun 2022 09:52:52 GMT

Hi @Heshan Karunaratne , you can use a tJavaFlex component to transform your list into a data flow and iterate the output.

you can also do something like this :

https://stackoverflow.com/questions/67820605/constructing-list-in-globalmap-and-retrieving-it-as-flow

Re: Convert List to excel output file

heshkaru — Fri, 17 Jun 2022 14:02:03 GMT

Hi gjeremy1617088143,

This partially helped me with the implementation.

Thank you very much

Re: Convert List to excel output file

Anonymous — Mon, 20 Jun 2022 06:56:13 GMT

Hello,

Which part of your expected output result can not be achieved by this solution when you use a tJavaFlex component to transform your list into a data flow and iterate the output?

Best regards

Sabrina