topic Re: Creating JSON target with multiple loops in Talend Studio

Creating JSON target with multiple loops

kmrprvn — Fri, 22 Jun 2018 15:35:25 GMT

Hi,

can someone tell me how can i create json target with mutlple loops. I tried using twriteJSONField and tFileOutputJson. but they were allowing only one loop. but i need to apply 2 loops for my requirement.

below is the source:

orderno,lineitem,quantity,shipment
121568,1,5,C-1528
121568,2,3,C-1529

sample target:

{
"order_info" :{
"orderno" : "121568",
"line_items":[ {
"lineitem": "1",
"quantity" : "5"
},
{
   "lineitem": "2",
"quantity": "3"
}
],
"shipments":[
    {
      "shipment_id" : "C-1528",
      "quantity" : "5"
    },{
      "shipment_id" : "C-1529",
      "quantity" : "3"
    }
    ]
}
}

Thanks in advance. Let me know if anything required.

Re: Creating JSON target with multiple loops

Anonymous — Thu, 16 Aug 2018 07:26:57 GMT

Hello,

It is impossible to create multiple loop elements with tWriteJsonField component. Right now, you can only generate a json file for each loop element.

Best regards

Sabrina

Re: Creating JSON target with multiple loops

Anonymous — Sun, 09 Dec 2018 21:25:19 GMT

Is it possible to get on multiple loop like this way?

Regards,
Smith