Last Modified Date: 20 Mar 2017
- Tableau Desktop
ResolutionOption 1: Modify the calculation to not use empty strings
Option 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]
CauseOracle does not follow standard conventions for CONCAT operator with null values.
Additional InformationNote: 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
Training and Tutorials