Convert List<X> to excel output file

[heshkaru]

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

[gjeremy1617088143]

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

[heshkaru]

Hi gjeremy1617088143,

This partially helped me with the implementation.

Thank you very much

[Anonymous]

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