Merging two queries from different datasource

[wlargou]

Hi,

Please have a look at this thread :

Table merge transform but "inner" join

With a Prometheus backend, I am trying to filter on the results of a few queries after running the Merge transform on them. To visualise: Query a (after filtering on a label): a | 1 b | 2 Query b (which doesn’t have the filter from a): a | 1 b | 2 c | 3 Merge gives the following table: a | 1 | 1 b | 2 | 2 c | | 3 But I don’t want to see row c. How can I remove it? I can do a join with metric a in each of the subsequent Prometheus queries, but I’d rather be able to to it in Grafana …

The current joint possible is what you get.

You can always apply for a feature request in GitHub.

Hope it helps.

Good Luck