tJava to tFileOutputDelimited returns null for initial value

[Anonymous]

Hi,

I have a job which parses a CSV output from an API. I am trying to dynamically set the file name, however, the first result of order number is always null, and then rest is 1 off.

The orderNumber shows correctly using System.out.println() in the tJava, so I'm assuming its something to do with the order that things are executed?

I have attached screenshots of both components & the workflow of the job.

Is there a way around this? I can't extract the order number directly from the JSON because its just a data object with csv inside of it.

Thanks

[Anonymous]

Adding a tJava before the tJavaFlex works.

Thanks a lot for the help and explanations @TRF @rhall.

I wouldn't have figured it out myself!

[Anonymous]

I got similar kind of problem with filenames and iteration. I wrote two files from one database row. First filename was always null and numbering was always one file off. I added tJava component just after flowToIterate component and this worked just perfectly!