Automate JOIN on visual, like in Zoho Analytics?

In Zoho Analytics, there is a way to directly link a column in a table to a column in another table. I.e. the classic Product/Customer/Order would have the id keys in each table linked with the matching column in the corresponding tables.

In visualizations, one could mix up the columns from the different tables and the JOINs would be made automatically. It’s very cool.

Is there a similar way to do this in QuickSight? Or do we have to edit or set up a new dataset for each field that needs to be joined?

There is not an automatic way to do that currently. You would need to join these two tables if you want the data to be available across both datasets.

1 Like