tWriteJsonField - Help - Cannot get Hierarchical output

[root]

I have some hierarchical data which I need to create a json object.

The way I have designed my job is very primitive... I just added these items in tWriteJsonField component, but, I am unaware of how to get the correct output.

I am attaching my job for anyone who would like to try and assist.

Desired OP:

[{
		"category": "Colors",
		"details": [{
			"category_detail": "Red",
			"total": "100"
		}, {
			"category_detail": "Yellow",
			"total": "200"
		}, {
			"category_detail": "Green",
			"total": "300"
		}]
	},
	{
		"category": "Shapes",
		"details": [{
			"category_detail": "Circle",
			"total": "400"
		}, {
			"category_detail": "Square",
			"total": "500"
		}, {
			"category_detail": "Triangle",
			"total": "600"
		}]
	}
]

Any help is appreciated.

[yome1]

Hello,

You probably can use TalendDataMapper (subscription version only)

https://help.talend.com/reader/0G_VvrRkdPvPXhSX86ghZQ/MDauhq9nl1m0FXZX~aHp9Q

[root]

nah, its open studio. thnx