topic How to change how a JSON Array is process in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-change-how-a-JSON-Array-is-process/m-p/1246209#M2424 <HTML><HEAD></HEAD><BODY><P>Hi - apologies newbie to Qlik so sorry if this is a silly question.....</P><P>I've got a JSON Array coming back from a REST API which looks like:</P><P>[</P><P>&nbsp; [</P><P>&nbsp;&nbsp;&nbsp; TIMESERIES,</P><P>&nbsp;&nbsp;&nbsp; VALUE</P><P>&nbsp; ],</P><P>&nbsp; [</P><P>&nbsp;&nbsp;&nbsp; TIMESERIES,</P><P>&nbsp;&nbsp;&nbsp; VALUE</P><P>&nbsp; ]</P><P>]</P><P>e.g. </P><P>[</P><P>&nbsp; [</P><P>&nbsp;&nbsp;&nbsp; 1488830820000,</P><P>&nbsp;&nbsp;&nbsp; 18.299999237061</P><P>&nbsp; ],</P><P>&nbsp; [</P><P>&nbsp;&nbsp;&nbsp; 1488830880000,</P><P>&nbsp;&nbsp;&nbsp; 18.299999237061</P><P>&nbsp; ]</P><P>]</P><P>I'd like it to be read into Qlik so that I can plot value against timeseries for the whole array.</P><P>However the data seems to be read in as:</P><P>Column 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column 2</P><P>Timeseries&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Timeseries&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>....</P><P>How can I either read the data in differently or manipulate it once in?</P><P>Many thanks,</P><P>Rupert</P></BODY></HTML> Tue, 21 Dec 2021 13:58:50 GMT 2021-12-21T13:58:50Z How to change how a JSON Array is process https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-change-how-a-JSON-Array-is-process/m-p/1246209#M2424 <HTML><HEAD></HEAD><BODY><P>Hi - apologies newbie to Qlik so sorry if this is a silly question.....</P><P>I've got a JSON Array coming back from a REST API which looks like:</P><P>[</P><P>&nbsp; [</P><P>&nbsp;&nbsp;&nbsp; TIMESERIES,</P><P>&nbsp;&nbsp;&nbsp; VALUE</P><P>&nbsp; ],</P><P>&nbsp; [</P><P>&nbsp;&nbsp;&nbsp; TIMESERIES,</P><P>&nbsp;&nbsp;&nbsp; VALUE</P><P>&nbsp; ]</P><P>]</P><P>e.g. </P><P>[</P><P>&nbsp; [</P><P>&nbsp;&nbsp;&nbsp; 1488830820000,</P><P>&nbsp;&nbsp;&nbsp; 18.299999237061</P><P>&nbsp; ],</P><P>&nbsp; [</P><P>&nbsp;&nbsp;&nbsp; 1488830880000,</P><P>&nbsp;&nbsp;&nbsp; 18.299999237061</P><P>&nbsp; ]</P><P>]</P><P>I'd like it to be read into Qlik so that I can plot value against timeseries for the whole array.</P><P>However the data seems to be read in as:</P><P>Column 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column 2</P><P>Timeseries&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Timeseries&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>....</P><P>How can I either read the data in differently or manipulate it once in?</P><P>Many thanks,</P><P>Rupert</P></BODY></HTML> Tue, 21 Dec 2021 13:58:50 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-change-how-a-JSON-Array-is-process/m-p/1246209#M2424 2021-12-21T13:58:50Z