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?
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.