topic Re: Extract Json file in Talend Studio

Extract Json file

hiba1 — Fri, 15 Nov 2024 22:57:52 GMT

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 !

Re: Extract Json file

Anonymous — Tue, 03 May 2022 13:57:38 GMT

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.

Re: Extract Json file

hiba1 — Wed, 04 May 2022 09:10:15 GMT

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.

Re: Extract Json file

Anonymous — Wed, 04 May 2022 15:13:14 GMT

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?

Re: Extract Json file

hiba1 — Wed, 04 May 2022 16:33:23 GMT

unfortunately , no .

I get this error