Extract Json file

[hiba1]

Hi team,

I use tWriteJsonFile with a group element (VervotechId) as mentioned in the screenshot

.

in my input i have 2 VervotechId so i want to separate the json files for each VervotechId.

I try to use tFileOutputRaw but it does not work for me.

Any help please !

[Anonymous]

If you remove your tFileOutputRaw and add a tLogRow in its place, do you see the JSON Strings output as separate Strings in the way you want? If so, you are half way there. The tFileOutputRaw will be initialised once for the whole Subjob. It won't create a new file for each row or by group. So, to get round this you can use a tFlowToIterate followed by a tIterateToFlow. This is demonstrated pretty well in this video....

https://www.youtube.com/watch?v=WpEH7hIAB4k

Once that is done, your tFileOutput will be initialised for each iteration. So you can have a new file created (or appended to) for each row of data.

[hiba1]

Hi @Richard Hall​  ,

thank you for your reply,

I add the tlogRow but I can't get the JSON Strings output as separate Strings however it displays 2 rows.

[Anonymous]

You appear to have 2 outputs there. I can't see the complete JSON for the first String, but it looks like you have many sections in an Object array. Using the method I mentioned with the tFlowToIterate and tIterateToFlow, that would lead to 2 files being created. Is that not correct?

[hiba1]

unfortunately , no .

I get this error