https://community.cloudera.com/t5/Support-Questions/Jolt-Nearly-perfect-just-need-to-remove-square-brackets/m-p/242304#M204107 <P>I'm so close with this but afraid I do need a hand with a jolt transformation. I've done most of the work but can't get the last transformation working. I need to have it output without the square brackets. </P><P><BR /></P><P>Here is my data:</P><PRE>{ "totalElements": 168, "columns": { "dimension": { "id": "variables/daterangehour", "type": "time" }, "columnIds": [ "1" ] }, "rows": [ { "itemId": "119050300", "value": "00:00 2019-06-03", "data": [ 120 ] }, { "itemId": "119050805", "value": "05:00 2019-06-08", "data": [ 98 ] }, { "itemId": "119050923", "value": "23:00 2019-06-09", "data": [ 172 ] } ] } } </PRE><P>This is my Jolt:</P><P><BR /></P><PRE>[{ "operation": "shift", "spec": { "rows": { "*": { "value": "[&amp;1].date", "data": "[&amp;1].data" } } } } ]</PRE><P><BR /></P><P>It gives me this result:</P><P><BR /></P><PRE>[ { "date" : "00:00 2019-06-03", "data" : [ 120 ] }, { "date" : "22:00 2019-06-09", "data" : [ 307 ] }, { "date" : "23:00 2019-06-09", "data" : [ 172 ] } ] </PRE><P>This causes my system issues, I actual need the data field like this:</P><P><BR /></P><PRE>[ { "date" : "00:00 2019-06-03", "data" : "120" }, { "date" : "05:00 2019-06-08", "data" : "98" } ]</PRE><P><BR /></P><P>How do I pluck the item out of the array / square brackets? It will only ever be one item in there.</P><P><BR /></P> Wed, 12 Jun 2019 01:43:46 GMT james_willson1 2019-06-12T01:43:46Z