Is JSON Structure handling difficult?

Actually not, If you understand the JSON structure. In this article we are going to see about the objects within JSON array.

So, Input structure will be like this. here there are six columns in this data.

Now, our output will be like this. Yes, we can use tWriteJSONField to create this structure, but the challenge is we can't get the array format if it single data. But we can achieve this below mentioned way.

We can read the input file in tFileInputDelimited component.

Now, configure the tWriteJSONField, if we double click the component we can get configure tree, there we can do all the mappings. before that, for looping purpose we can add dummy value as mentioned in the below image. (refer this - already we have discussed the same for xml structure).

tWriteJSONField

Once mapped all the values. we need to add the class attribute. Once dialogue box opened we need to mention it as class. In fixed value we need to mention it as array for outer level, and object for next level of values.

Now, In tWriteJSONField configuration we need to set the group by value and disable the remove root node option in the component.

Now if we run the job we'll get the required output.