How to cross join two query

I read that variable cannot be used in transform.
But I need this.

https://community.grafana.com/t/how-to-use-a-variable-in-a-transformation-regex/35864

So tried two query concatenated and calculation.

However, result like this.

How to cross join two queries?

Is there a better way?

+We using json api, not using flux.

@lsg1

it’s not entirely clear to us community users what your data looks like, or how you want to transform your data and make it appear. Maybe some screenshots would help.

or can you please follow these steps to share your raw unformatted data? That way, the community can try and mock up your problem :+1: