Last Modified Date: 10 Jul 2017
- Tableau Desktop
replace ISNULLS or IFNULLS with a RAWSQL_STR() function:
For example, replace
IFNULL([STR1],"") + IFNULL([STR2],"")
CauseOracle interprets blank strings as nulls automatically, so with every refresh it re-casts the blanks that the calculated field is creating as nulls again.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials