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年前735ビュー
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年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ