Joining Datasets with != Conditions in Quicksight

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?

Fabrizio@AWS 전문가
2년 전
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

주제

분석

태그

아마존 QuickSight

언어

English

Geoff

질문됨 2년 전764회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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

전문가

Fabrizio@AWS

답변함 2년 전

Joining Datasets with != Conditions in Quicksight

관련 콘텐츠