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
asked a year ago221 views
1 Answer
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

EXPERT
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions