KNOWLEDGE BASE

Isnull() Does Not Return True Value For Late-Binding Views In Amazon Redshift


Published: 10 Sep 2020
Last Modified Date: 18 Sep 2020

Issue

ISNULL not detecting nulls when connected live to late-binding Redshift view

Environment

  • Tableau Desktop 
  • Amazon Redshift

Resolution

You can get around this behavior by using a Custom SQL statement like this
Select * From <actual name of the Schema that is being used>

Doing so will produce the correct results for this behavior.

 


 

Cause

ISNULL not detecting nulls when connected live to late-binding Redshift view. Currently we are unable to return true values when using the ISNull calculated field for latebinding redshift views. This issue is under investigation by Tableau development team.
Did this article resolve the issue?