Last Modified Date: 24 Jan 2019
Environment
Tableau PrepResolution
Replace any join key field containing nulls with a calculated field using one of the functions for null handling in Tableau.If the join key is a string:
IFNULL([join key], '')will replace null values with empty strings.
If the join key is a number:
ZN([join key])
will replace null values with zeroes.
Cause
In a relational database, a null is not a value, a null is the absence of a value.Because of this, two nulls are not treated as logically equivalent, and null join key values are ignored.
Additional Information
Nulls Handling - String, Date, Numerical Data typesNull (SQL) at Wikipedia
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials