twritejsonField does not loop in item array. output is 2 seperate Objects

Anonymous — Thu, 31 Jan 2019 19:28:26 GMT

I have to convert the txmlmap columns to json in this format.

Expected output:

{
"addresses": [
{
"request_id": "00Qa000001UIjN7",
"street": "565 de la montagne street",
"city": "Valcourt",
"state_code": "CA-QC",
"country_code": "CA",
"postal_code": "J0E 2L0",
"geo_location": {
"type": "Point",
"coordinates": [
-72.303871,
45.488386
]
}
},
{
"request_id": "00Qa000005545",
"street": "2050 andré",
"city": "sherbrooke",
"state_code": "CA-QC",
"country_code": "CA",
"postal_code": "J1H 6C4",
"geo_location": {
"type": "Point",
"coordinates": [
-72.303871,
45.488386
]
}
}
]
}

but it is always supplied in 2 different objects I do not why;, her what I get:

{"addresses":[{"request_id":"00Qa000001UIjN7","street":"565 RUE DE LA MONTAGNE","city":"VALCOURT","state_code":"QC","country_code":"CAN","postal_code":"J0E 2L0","geo_location":{"type":"Point","coordinates":["45.49133","-72.312679"]}}]}
{"addresses":[{"request_id":"00Qa000005545","street":"2050 RUE ANDRÉ","city":"SHERBROOKE","state_code":"QC","country_code":"CAN","postal_code":"J1H 6C4","geo_location":{"type":"Point","coordinates":["45.373436","-71.9029483"]}}]}

here, my job:

txmlmap content, I added a coloumn loop and made it as output in twritejsonfield. people said it resolve the problem. But, not in my case

My content twritejsonfield:

Re: twritejsonField does not loop in item array. output is 2 seperate Objects

vapukov — Thu, 31 Jan 2019 22:24:11 GMT

did you add group by (in standard properties of tWriteJSONFields)?

as I understand your structure - group by column loop

Re: twritejsonField does not loop in item array. output is 2 seperate Objects

Anonymous — Thu, 31 Jan 2019 22:48:56 GMT

Yes I did that. I still have the same problem

Re: twritejsonField does not loop in item array. output is 2 seperate Objects

Anonymous — Fri, 01 Feb 2019 16:20:21 GMT

any idea how to resolve the problem, i made the group by on the loop column, but not working

topic Re: twritejsonField does not loop in item array. output is 2 seperate Objects in Talend Studio

twritejsonField does not loop in item array. output is 2 seperate Objects

Re: twritejsonField does not loop in item array. output is 2 seperate Objects

Re: twritejsonField does not loop in item array. output is 2 seperate Objects

Re: twritejsonField does not loop in item array. output is 2 seperate Objects