Unable to get data block

Anonymous — Thu, 25 May 2017 14:33:49 GMT

Hi,

I am getting incomplete format in tfileInputDelimited as below.

{"name":"WDCi","locations":[{"location":"KL","staffs":[{"staff":"Lean","new_Loc":" KL"},{"staff":"Kai Herng","new_Loc":" KL KL"}]},{"location":"Sydney","staffs":[{"staff":"Walter","new_Loc":" KL KL Sydney"},{"staff":"Deborah","new_Loc":" KL KL Sydney Sydney"}]},{"location":"US","staffs":{"staff":"Terry","new_Loc":" KL KL Sydney Sydney US"}}]}

I need output for the same job as below.

{"company":

My job:

My actual data:

{"company":{"name":"WDCi","locations":[{"location":"KL","staffs":[{"staff":"Lean"},{"staff":"Kai Herng"}]},{"location":"Sydney","staffs":[{"staff":"Walter"},{"staff":"Deborah"}]},{"location":"US","staffs":{"staff":"Terry"}}]}}

Please suggest what needs to be done. Kindly reply as early as possible.

Re: Unable to get data block

Anonymous — Mon, 12 Jun 2017 07:31:00 GMT

Hi
It seems the new_Loc element is missing from the output data, you might don't configure the json tree correctly. Can you please upload some screenshots of basic settings of tWriteJsonField component?

Regards
Shong

topic Unable to get data block in Talend Studio

Unable to get data block

Re: Unable to get data block