Last Modified Date: 20 Jul 2023
Environment
- Tableau Desktop
- Oracle
Resolution
Option 1: Modify the calculation to not use empty stringsOption 2: Use an extract rather than a live connection
Option 3: Conditionally concatenate strings only if they are not empty. For example:
IF LEN( [String calculation 1] ) > 0
AND LEN( [String calculation 2] ) > 0
THEN [String calculation 1] + [String calculation 2]
ELSEIF LEN( [String calculation 1] ) > 0
THEN [String calculation 1]
ELSE [String calculation 2]
END
Cause
Oracle does not follow standard conventions for CONCAT operator with null values.Additional Information
Note: when the extract is refreshed Tableau Desktop will query the Oracle data causing the calculated field to return NULL. Therefore after refreshing the extract, the calculated field will need to be remade.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