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

Question & Answer
,
1

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.

image
image1182×367 14.4 KB

2

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
3

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