topic Re: [resolved] Parse Multiple json documents from single file in Talend Studio

[resolved] Parse Multiple json documents from single file

Anonymous — Thu, 06 Oct 2016 22:50:42 GMT

I am trying to parse multiple json documents from a single file using following job design
tfileinputfullrow -> tfileinputjson - tmap - tfileoutputdelimited(csv)
Job is iterating through all the 16 rows in that in the file, but outcome is being substituting the first row unique id for the all the rows that is being generated. My file has 10 rows similar like where a uuid and name are different for each customer and may like multiple styles. please let me know ideas on how we can achieve it.

thanks

Re: [resolved] Parse Multiple json documents from single file

Anonymous — Sat, 08 Oct 2016 12:03:02 GMT

Hi
tFileInputJson is used to read data from a json file. In this case, I think you need to iterate each row and extract data from each row using tExtractjsonFields, the job looks like:
tfileinputfullrow -main--tFlowToIterate--iterate-- tFixedFlowInput-main-tExtractJsonFields- tfileoutputdelimited(csv)
tFixedFlowInput: generates the current row.

Regards
Shong

Re: [resolved] Parse Multiple json documents from single file

Anonymous — Sat, 08 Oct 2016 18:30:56 GMT

Thanks Shong.. this worked perfectly. I'm marking this topic as resolved.

Re: [resolved] Parse Multiple json documents from single file

Anonymous — Sat, 08 Oct 2016 22:05:26 GMT

Great, thanks for your feedback.

Re: [resolved] Parse Multiple json documents from single file

Anonymous — Wed, 27 Jun 2018 16:19:27 GMT

I am facing the same issue. Can u please share the component details for tFixedFlowInput and ExtractJsonFields.

Re: [resolved] Parse Multiple json documents from single file

kuwaryogi27 — Wed, 10 Jul 2019 11:09:47 GMT

Hello @shong ,

can you please share the configuration for tFixedFlowInput and tExtractJsonFields

Regards,
Yogesh.

Re: [resolved] Parse Multiple json documents from single file

Anonymous — Wed, 10 Jul 2019 11:23:35 GMT

@ykasture, This topic was a little old, I don't have the job any more. Please refers to the component documentation if you don't know how to uses these components, open a new thread if you have any questions or meet any issue.

Re: [resolved] Parse Multiple json documents from single file

kuwaryogi27 — Wed, 10 Jul 2019 11:24:43 GMT

@shong , Okay creating a new thread please guide me for the same.