Transfer data from one log to another

  • What Grafana version and what operating system are you using?
    *10.2 + Datasource Elasticsearch

  • What are you trying to achieve?
    I always have two logs that belong together (request and client). They are linked by their RequestId.
    Now I want the traceId from the request log to be transferred to the traceId_request column of the client log, but I want to make sure that they have the same requestId.
    Is this possible in Grafana?

  • How are you trying to achieve it?
    All attempts were made in Logstash but this is technically not possible as I have a timing problem there.

Many thanks in advance!

Make 2 queries (not just one):

  • only requests
  • only clients

Use Grafana transformation - join by field and use requestid to join these 2 results.

1 Like

Thank you very much!