Joining Datasets with != Conditions in Quicksight

Question

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?

Answer

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

Joining Datasets with != Conditions in Quicksight

Contenido relevante