https://community.cloudera.com/t5/Support-Questions/Converting-SQL-record-to-JSON/m-p/336674#M232344 <P>I've added a "remove" operation to the chain to solve the problem I mentioned in the last post, removing the "null" in the first position of the "measures" array:</P><LI-CODE lang="markup">[ { "operation": "shift", "spec": { "LevelID": "assetId", "PLCTime": "datapoints[0].timestamp", "Data*Type": "datapoints[0].measures[&amp;(0,1)].name", "Data*": "datapoints[0].measures[&amp;(0,1)].value" } }, { "operation": "remove", "spec": { "datapoints": { "*": { "measures": { "0": "" } } } } } ]</LI-CODE><P>&nbsp;</P><P>This should give you the exact output you were looking for.</P><P>&nbsp;</P><P>HTH,</P><P>André</P><P>&nbsp;</P> Mon, 21 Feb 2022 01:31:16 GMT araujo 2022-02-21T01:31:16Z