How to combine 2 query into 1

Grafana
,
13

If you are talking about missing all null columns, you need to handle this in your JSONata query.

something like…

$map($.result.data_array, function($row){
    $merge($map($$.manifest.schema.columns,function($key, $key_index){
       return {
          $key.name : $type($row[$key_index]) = 'null'  ? "" : $row[$key_index]
       }
    }))
})