If you're using Tableau Desktop, you may create a datasource filter that uses the second data source's join key.
1. From source1 to source2, create a left join.
2. Create a new datasource filter for source2.join key by going to the "Condition" tab, selecting "By formula," and using "ISNULL([source2.join key])" as the formula.
Elevate your data visualization skills with our Tableau Course and unleash the power of insightful analytics.