3 Replies Latest reply on Nov 13, 2018 8:51 AM by Dan Cory

    Receiving Null Values when i use a calculated field in the worksheet connecting to Amazon Redshift Database

    Suresh Krishna

      Hi All,

       

      I am Receiving Null Values when i use a calculated field in the worksheet connecting to Amazon Redshift Database. I am establishing a connection from tableau desktop to Amazon Redshift database through other database connections(ODBC). 

       

      Example:

       

      I have a field called City which is a dimension field directly pulled from the database table. When i use that dimension in my worksheet it shows value it contains. PFB the screenshot with sample values in it.

       

      When i use the same City field in a new calculation and i am naming it as calculation1. When i use that calculation1 field which is of the same data type like the original City dimension  in my worksheet, it gives me null value even though the base field has the data.

       

       

      I am not able to find what is causing this issue. Kindly let me know if this is a known issue when connecting amazon redshift database through ODBC.

       

      Regard,

      Suresh