0 Replies Latest reply: Mar 7, 2017 2:54 PM by Rupert Ogilvie RSS

    How to change how a JSON Array is process

    Rupert Ogilvie

      Hi - apologies newbie to Qlik so sorry if this is a silly question.....

      I've got a JSON Array coming back from a REST API which looks like:

      [

        [

          TIMESERIES,

          VALUE

        ],

        [

          TIMESERIES,

          VALUE

        ]

      ]

      e.g.

      [

        [

          1488830820000,

          18.299999237061

        ],

        [

          1488830880000,

          18.299999237061

        ]

      ]

      I'd like it to be read into Qlik so that I can plot value against timeseries for the whole array.

      However the data seems to be read in as:

      Column 1       Column 2

      Timeseries          1

      Value                  1

      Timeseries          2

      Value                   2

      ....

      How can I either read the data in differently or manipulate it once in?

      Many thanks,

      Rupert