How to merge two table


I have 2 elasticseach datasources in Grafana 8.5. One has the following fields: timestamp1,host, group. The second one has: timestamp2,host, event,eventid,source,message.

What I want to do is to create a table that includes:timestamp2,host, group,event,eventid,source,message.

I tried doing this with mixed datasource panel in Grafana, however could not achieve it. I am even not sure if this is something doable.

Any solution/recommendation is appreciated.

Thanks in advance.

Generally: create 2 datasource queries, which will have one common field host. Then add join transformation to join 2 results by host field into one result.
You may need upgrade your old Grafana 8 for that.