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

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


1 Like

hey… I am new to Quicksight… I have a similar question like yours, but when we add new data, how to change join configuration with different tables? in my dataset, it is always relating to the same table