Joining Datasets with != Conditions in Quicksight

1

I'm trying to create a dataset from two existing datasets, all in SPICE. The new/synthetic dataset is basically for de-duplication, so I'm trying to join on one field (the email domain of a contact) but join with a != or a ideally a < criteria for the client ID. In the Quicksight UI, I can only use = as the condition for a join at this time.

I could easily accomplish what I'm trying to do if I could access an SQL-like interface for the joining of the two SPICE datasets, but I can't see in the UI how to join datasets without using the GUI with all of its limitations.

Any insights or thoughts?

  • could you please share the SQL code you have in mind? Usually anti-joins and semi-joins can be replaced by other forms of joins and filter on the data. Thank you

Geoff
已提问 2 年前734 查看次数
1 回答
0

could you please share the SQL code you have in mind, so I can build an example?

Usually anti-joins and semi-joins can be replaced by other forms of joins and filters on the data.

So for example if you want to get all data from the join from the left table ( l) on l.key != r.key, you could use the left outer join and then add a filter on r.key is null. Thank you

AWS
专家
已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则