Any way to form a join manually between tables when creating a data set?

Hi. Is there a way to form a join between “Reflexis” and “Calendar master” in addition to already existing join with “store master”? I know PowerBI allows to do something like this, does QuickSite have that kind of functionality? Looks like currently I can only connect “Reflexis” to “store master” OR “calendar master”… Any way to have both? Thanks.

Hi @obaranets
Option 1: You can write customSQL if both tables are from the same data source
https://docs.aws.amazon.com/quicksight/latest/user/adding-a-SQL-query.html

Option 2: Please add the Reflexis again as another entity using Add Data button

Regards
Vetri

1 Like