tFileOutputJSON output formating

One Star

tFileOutputJSON output formating

Hi everyone 
I use 5.6 version and In a transformation I need to generate a large JSON file so I use tFileOutputJSON component. the problem is that the generated output is a single line JSON file which has more data than java can handle in a single line. any idea on how can I avoid this behavior and create a well formed JSON file?
Best,  
Moderator

Re: tFileOutputJSON output formating

Hi,
Could you please explain your request with some example data? What's your expected json output?
Here is a component
TalendHelpCenter:tWriteJSONField which is used to transform the incoming data into JSON fields.

Best regards

Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tFileOutputJSON output formating

Hi Sabrina
Thanks for the hint. Breaking the file down to records and writing them individually using tWriteJSONField solved the problem of formating the json file.
Best,
Yashar
Moderator

Re: tFileOutputJSON output formating

Hi Yashar,
Thanks for your feedback. Could you please mark this topic as resolved if this problem is solved?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.