tWriteJsonField - Help - Cannot get Hierarchical output

root — Sat, 16 Nov 2024 06:54:20 GMT

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.

Re: tWriteJsonField - Help - Cannot get Hierarchical output

yome1 — Tue, 08 Jan 2019 21:28:27 GMT

Hello,

You probably can use TalendDataMapper (subscription version only)

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

Re: tWriteJsonField - Help - Cannot get Hierarchical output

root — Tue, 08 Jan 2019 21:45:41 GMT

nah, its open studio. thnx

topic Re: tWriteJsonField - Help - Cannot get Hierarchical output in Talend Studio

tWriteJsonField - Help - Cannot get Hierarchical output

Re: tWriteJsonField - Help - Cannot get Hierarchical output

Re: tWriteJsonField - Help - Cannot get Hierarchical output