How to avoid NULL check in JOIN condition in Tableau

0 votes
I'm attempting to alter the Tableau dashboard's backend database. Tableau generates JOIN SQLs that include conditions like: ON a.col1 = b.col2 OR (a.col1 is null and b.col2 is null) Is there a method to avoid the OR condition (a.col1 is null and b.col2 is null)? I tried using ZN and IFNULL with the column name, but the conditions continue to be added. The Druid DB only supports JOIN with equality conditions, and the query fails due to the IS NULL check. Thanks
May 16, 2022 in Tableau by Neha
• 9,020 points

edited Mar 4 1 view

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP