Concatenate multiple queries as rows instead of column

[oracion]

• What Grafana version and what operating system are you using?
  Grafana 11.20
• What are you trying to achieve?
  Multiple queries to rows
• How are you trying to achieve it?
  Using concatenate fields
• What happened?
  Multiple queries concatenated to column
• What did you expect to happen?
  Multiple queries concatenated as rows
• Can you copy/paste the configuration(s) that you are having problems with?

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
  No
• Did you follow any online instructions? If so, what is the URL?
  No

I have a query that looks like this:

I want it to show all the queries in one table, so i use the concatenate fields. But it combines the query to column instead of row

What i want is like this:

Does anyone have an idea how?

[sowdenraymond]

i got it close:

[dawiddebowski]

Hi, not a tested solution but wouldn’t using just the Merge transformation suffice? You might need to play around with column naming first (organize fields transformation with filters) so that the columns names are the same but I think it could work.

[yosiasz]

are both data sources mysql and both on the same server?

[oracion]

Both are from different postgresql database, but have the same column name. I managed to get it like this:

But it adds suffix to column name like 1 and 2 (lastlogin 1, lastlogin2, active1, active2).

What i want to achieve is something like this:

[oracion]

Sorry for the trouble, i manage to solve it using the query above and this transformation:

Thank you all for responding.