topic Re: create two nested arrays in Talend Studio

create two nested arrays

kakooo16 — Wed, 14 Dec 2022 15:09:35 GMT

I'm having a problem using twriteJsonField component as it does not allow to specify Multiple loop element

my input is as below :

-----------------------------------------------

-----------------------------------------------

------------------------------------------------

Now , i want to generate this json :

_____________________________________________________

{

"line_list":[

{

"line_year":"2012",

"comment_list":[

{

"action":"Action1",

"group":"group1",

"comment":"comment1"

}

]

{

"line_year":"2020",

"comment_list":[

{

"action":"Action2",

"group":"group2",

"comment":"comment2"

}

]

}

]

}

___________________________________________________________

How could i acheive this please ?

Re: create two nested arrays

Anonymous — Wed, 14 Dec 2022 17:21:07 GMT

Hi Team,

tWriteJsonField does not support multiple loop elements.

That being said, One way to create complex json is using custom components like these here:

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F1438&pi=marketplace%252F1%252Fproducts%252F1438%252Fitems%252F2982

Best,

Yussef

Re: create two nested arrays

kakooo16 — Wed, 14 Dec 2022 17:31:15 GMT

could you help do that ?

Re: create two nested arrays

Anonymous — Wed, 14 Dec 2022 19:18:02 GMT

There are a couple of ways you can approach this.

You can use Talend Data Mapper....but this is restricted to licensed versions
You can take a look at @Jan Lolling's JSON components. He went through these in the post we last discussed modifying JSON on
You can do this in a step by step way, using multiple tWriteJSONField components (one to deal with the inner loop and another to deal with the outer loop, then merging the content)
You can use some Java, in a similar way to how I built a solution using the JSONObject, JSONArray, etc, classes. This was demo'd in the last conversation we had on this.

Re: create two nested arrays

kakooo16 — Wed, 14 Dec 2022 20:51:41 GMT

Could you give me an example on how to acheive that , i have datamapper .

Any solution would be appreciated .