Mixed datasources based on joined id column

I want to join a few data sources: PostgreSQL, ADX, and azure monitor into one combined table using joined column of id.
I tried to use “Mixed”, but it is not working it just give me an option to switch between the queries outputs in the same visualization table (photo is attached)

I would like to see the joined query in the table at the same time.
How can I do that?

I am using v8.1.0

Hi @stavb

Once you find yourself in that situation (in your screenshot, where you can choose from multiple tables in a dropdown), then try using a transformation like merge. That should attempt to merge the tables into one.

The transformation only works if the data is from tables from the same source.
I would like to combine few data sources.
Any idea?