It would be really helpful to have an option to exclude from a join. This is intended for “exceptions”. Right now, I have to do a full left join and then a transform to get this. It would be great to be able to do this in one step.
SQL example:
select * from TABLE_1
where Unique_ID is not in
(select Unique_ID from TABLE_2)
Hi
Do a left join of TABLE_1, TABLE_2 on Unique_ID. Then filter for TABLE_2.Unique_ID =! null
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
