Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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,  
Labels (4)
3 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Hi Yashar,
Thanks for your feedback. Could you please mark this topic as resolved if this problem is solved?
Best regards
Sabrina