https://community.cloudera.com/t5/Support-Questions/Jolt-Nearly-perfect-just-need-to-remove-square-brackets/m-p/242305#M204108 <P><A rel="user" href="https://community.cloudera.com/users/114559/jameswillson1.html">@James Willson</A></P><P><BR /></P><P><STRONG>Try with below spec:</STRONG></P><PRE>[{ &nbsp; &nbsp; "operation": "shift", &nbsp; &nbsp; "spec": { &nbsp; &nbsp; &nbsp; "rows": { &nbsp; &nbsp; &nbsp; &nbsp; "*": { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "value": "[&amp;1].date", &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "data": { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "*": "[#3].data" &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } &nbsp; &nbsp; &nbsp; &nbsp; } &nbsp; &nbsp; &nbsp; } &nbsp; &nbsp; } } ]</PRE><P>Gives <STRONG>output that you are looking for:</STRONG></P><PRE>[ { &nbsp; "date" : "00:00 2019-06-03", &nbsp; "data" : 120 }, { &nbsp; "date" : "05:00 2019-06-08", &nbsp; "data" : 98 }, { &nbsp; "date" : "23:00 2019-06-09", &nbsp; "data" : 172 } ]</PRE><P>-</P><P>If the answer is helpful to resolve the issue, <STRONG>Login and Click on Accept button</STRONG> below to close this thread.This will help other community users to find answers quickly <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 12 Jun 2019 07:36:23 GMT Shu_ashu 2019-06-12T07:36:23Z