Convert DataSet Tag to Json

Ignition
, ,
1

I have quey tag showing return [6Rows* 2Coulms ] . I used system.util.jsonEncode function to convert the Dataset to JSON format, below my outcome.

{
   "columns":[
      {
         "name":"Consumption",
         "type":"java.lang.Double"
      },
      {
         "name":"LineName",
         "type":"java.lang.String"
      }
   ],
   "rows":[
      [
         26683.0,
         "CANLine 1"
      ],
      [
         23510.0,
         "CANLine 2"
      ],
      [
         58977.2998046875,
         "CANLine 3"
      ],
      [
         567.0,
         "RBGlass Line"
      ],
      [
         16586.0,
         "PETLine 1"
      ],
      [
         21981.0,
         "PETLine 2"
      ]
   ]
}

How can i remove the first two sets of values to be as below to use in X-Y Chart?

{
   "rows":[
      [
         26683.0,
         "CANLine 1"
      ],
      [
         23510.0,
         "CANLine 2"
      ],
      [
         58977.2998046875,
         "CANLine 3"
      ],
      [
         567.0,
         "RBGlass Line"
      ],
      [
         16586.0,
         "PETLine 1"
      ],
      [
         21981.0,
         "PETLine 2"
      ]
   ]
}
2

Hi
Bind that tag to the data section of your xy chart and then add python script transform and loop through your json and convert it to dataset.
Just remove the columns keyword in your dictionary

3

As Nader said, just remove the key from the dictionary, eg
obj.pop('columns', None)

pop removes the key whether it exists or not and returns the value of the key, or the fallback (in this case None) of it didn’t exist. You don’t need to do anything with the return