DB to JSON file

Anonymous — Sat, 16 Nov 2024 03:58:32 GMT

I am using talend to create json file from a database table.

Talend creates the file as below

[{"Col1":"Val1"},{"Col2":"Val2"},{"Col3":"Val3"}]

But I need the file to be in below format

{"Col1":"Val1"}

{"Col2":"Val2"}

{"Col3":"Val3"}

Because this is how its accepted in target.

Any way to make this work. I can use tWriteJSONField but I have to map it manually. There are multiple tables and I want to make this as a framework which can accept table names as context variable and produce the json in the above format. Any suggestions?

Re: DB to JSON file

Anonymous — Thu, 05 Dec 2019 11:52:04 GMT

Hi Stevens
Take a look at tNormalize component.
https://help.talend.com/reader/LNO9Tqm8svZQklRyXL8OYw/yV2ZEYW9mADj~cYLcbhFWA
After you generate the Json file, read the whole file as a string using tFileInputRaw, remove the characters "[","]", and then normalize the line to multiple lines.

Regards
Shong

topic DB to JSON file in Talend Studio

DB to JSON file

Re: DB to JSON file