Need To Iterate all the rows in subjob from Main job and want to creating a single json file with append for all the rows iterated
Hi ,
My scenario is like this-
i am passing some set of columns in parameter context from main job to the child/sub job in multiple iterations .Now i need to create rows and save it in single json file with appending all the rows.
If JSON doesnt support the append feature and CSV is a workaround then how i can transform the CSV to JSON at the last iteration of the subjob. How can i put a check that all the rows from parent job got fetched and now i can create json in subjob ?
I suggest you to return the generated json string from child to parent job user tBufferOutput. In parent job, concatenate result from each child into a global variable and write it into a file using tFileOutputRaw when all irerations are finished.
