i try to retrieve data from influxDB. but I don't know how to parse the result that columns and values are separated.
| makeresults
| eval results= {"series":[{"values":[["2019-10-25T06:02:18.369115741Z","A","1"],["2019-10-25T06:03:33.4004666Z","B","2"],["2019-10-25T06:04:01.104011287Z","C","3"],["2019-10-25T06:04:08.673023079Z","D","4"]],"columns":["time","field","tag"],"name":"test_measurement"}],"statement_id":0}
| ???
can it be transformed into the table below?
|time|field|tag|
|2019-10-25T06:02:18.369115741Z|A|1|
|2019-10-25T06:03:33.4004666Z|B|2|
|2019-10-25T06:04:01.104011287Z|C|3|
|2019-10-25T06:04:08.673023079Z|D|4|
... View more