Comparing Two Queries in Grafana and display only unique results

Question

Ok, here is my scenario. I am querying two separate data sources in Grafana 7.1.x. In both datasources I am querying a table with a column where the entries can match (like key fields in a single database). What I want to do is display the results from query A ONLY if the key value does NOT also appear in query B. In other words, use query B to exclude results from query A in the table. I tried messing with transforms but I couldn't make it work.

question from:https://stackoverflow.com/questions/66055254/comparing-two-queries-in-grafana-and-display-only-unique-results

Answer 1

Waitting for answers