Create a JSON file using features of native tWriteJSONField component - loop and group by

aviralagl — Wed, 12 Jun 2019 23:04:19 GMT

I have a joblet ouput with schema as below:

id
attr1
attr2
attrNext

I would like to create a JSON file that looks like below:

[ {
      "id":"100001",
      "attrMain":[
         {
            "attr1":"aa",
            "attr2":"abc@xyz.com"
         },
         {
            "attr1":"bb",
            "attr2":"pqr@abc.com"
         },
         {
            "attr1":"cc",
            "attr2":"xyz@xyz.com"
         },
      ]
   }
]

I have so far been using tWriteJSONField with a Group by over "id" & setting attrMain as the group element, and attr1 as loop element in the "Configure JSON Tree" editor. I would like to achieve the same using tJSONDoc* components. So far, I have been able to get the below output (screenshot of job attached):

[   {
  "id" : "100001",
  "attrMain" : [ {
    "attr1" : "aa"
  }, {
    "attr2" : "abc@xyz.com"
  } ]
}, {
  "id" : "100001",
  "attrMain" : [ {
    "attr1" : "bb"
  }, {
    "attr2" : "pqr@abc.com"
  } ]
}, {
  "id" : "100001",
  "attrMain" : [ {
    "attr1" : "cc"
  }, {
    "attr2" : "xyz@xyz.com"
  } ]
} ]

Any suggestions? Happy to provide more information on request!

Re: Create a JSON file using features of native tWriteJSONField component - loop and group by

Anonymous — Mon, 01 Jul 2019 08:09:45 GMT

Hello,

tJsonDocOutput is a custom component written by talend community user and shared on talend exchange portal.

We don't have the source code of these components. It is the ownership of the person who built it. Feel free to contact the author directly.

Best regards

Sabrina

topic Create a JSON file using features of native tWriteJSONField component - loop and group by in Talend Studio

Create a JSON file using features of native tWriteJSONField component - loop and group by

Re: Create a JSON file using features of native tWriteJSONField component - loop and group by