https://community.cloudera.com/t5/Support-Questions/Converting-SQL-record-to-JSON/m-p/336671#M232342 <P>The spec below does almost what you need. The only thing is that your data points are numbered starting from 1 and JSON array are zero-based, so when the Jolt transformation is applied the first element of the "measures" array is left null.</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" } } ]</LI-CODE><P>&nbsp;</P><P>Cheers</P><P>André</P> Sun, 20 Feb 2022 11:39:56 GMT araujo 2022-02-20T11:39:56Z