Hello!
I am trying to create a table view of some JSON Data. To be precise, I have TWO JSON arrays with “Insights” and I want to display those objects in rows on my table.
But in order for me to do this, I need to have those two data merged, and I can’t do this on the source of the data - It’s not possible. I need to merge and transpose them.
So, I already was able to merge them two into one table, using merge:
First, this is the two tables with data, so you can understand.
Secondly, this is how it is after I merge them.
As you can see in the image, I now have two rows, each one containing the extracted data from each JSON array - In order for me to display them correctly, I need to join those two rows and instead of displaying each object in columns on different rows, make them display all together (So then I can use Reduce > Series to Rows and Extract Fields to appear it like the image below - But I can only make it work when using one table only.)
Here’s the desired result (The image below was acomplished using ONE table only - I can’t do it when using multiple arrays):
So, as you can see in the image above, when there’s just ONE array, I can display JSON on Grafana Table perfectly, but in order to do this for multiple arrays, I need to first join their columns for each row in one row only so I can do the same transformations as this image above.
Any help is appreciate it.