Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Normalize the data in JSON

Hi,

I have the input data in below format: { "kind": "insert", "table": "test", "columnnames": ["col1", "description"], "columntypes": ["integer", "character varying"], "columnvalues": [5, "test5"] }

I need the target data as: { "kind":"insert", "table":"test", "col1":"5", "description":"test5" }

I need to normalize the data getting key and value pairs from different arrays. I am trying with processors Field Pivoter, Field Merger and Field Flattener. But did not give the required results.

Please suggest me approach to normalize the data and convert into JSON

Normalize the data in JSON

Hi,

I have the input data in below format: { "kind": "insert", "table": "test", "columnnames": ["col1", "description"], "columntypes": ["integer", "character varying"], "columnvalues": [5, "test5"] }

I need the target data as: { "kind":"insert", "table":"test", "col1":"5", "description":"test5" }

I need to normalize the data getting key and value pairs from different arrays. I am trying with processors Field Pivoter, Field Merger and Field Flattener. But did not give the required results.

Please suggest me approach to normalize the data and convert load into JSON MongoDB