Help - tWriteJsonField (Duplicate Rows)

root — Sat, 16 Nov 2024 07:19:06 GMT

I have some data which I need to create a JSON.

My sample data shows like this:

Raw DatatWriteJson - Properties

Column dup_code/ dup_desc is the trouble point. What is happening is that the output JSON is repeating the whole JSON content. I guess its a limitation of being able to set a single loop element.

I am trying to get an output where the data is not duplicated.

{
	"My_Data": {
		"metadata": {
			"name": "name",
			"zip": "zip"
		},
		"op": [{
			"m_id": "1",
			"f_dt": "2011-01-01",
			"t_dt": "2011-02-01",
			"x": [{
				"x_position": "1",
				"x_code": "dc1"
			}, {
				"x_position": "2",
				"x_code": "dc2"
			}, {
				"x_position": "3",
				"x_code": "dc3"
			}],
			"dup": [{
				"dup_code": "dup1",
				"dup_desc": "dup1_desc"
			}, {
				"dup_code": "dup2",
				"dup_desc": "dup2_desc"
			}]
		}, {
			"m_id": "2",
			"f_dt": "2011-02-01",
			"t_dt": "2011-03-01",
			"x": {
				"x_position": "3",
				"x_code": "dc3"
			},
			"dup": {
				"dup_code": "c1",
				"dup_desc": "c1_desc"
			}
		}]
	}
}

What are my options here?

Attached is my job for ready reference

Thanks in advance

Re: Help - tWriteJsonField (Duplicate Rows)

root — Wed, 14 Nov 2018 21:51:58 GMT

Shameless bump. Any help please?

topic Help - tWriteJsonField (Duplicate Rows) in Talend Studio

Help - tWriteJsonField (Duplicate Rows)

Re: Help - tWriteJsonField (Duplicate Rows)