Creating JSON target with multiple loops

[kmrprvn]

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.

[Anonymous]

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

[Anonymous]

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

Regards,
Smith