1 Reply Latest reply: Jun 26, 2014 1:44 AM by Alan Walters RSS

    BigQuery connector: String reference not set to an instance of a string

      Hi everyone,

       

      I've been using Qlikview's BigQuery connector to retrieve data from tables in bigquery datasets.

       

      Here's a very simple sample query:

       

      CUSTOM CONNECT TO...
       
       tableA:
       SQL SELECT *
       
       FROM tableA; 
      
      

       

      However I noticed that whenever a string type field contains null values, Qlikview throws a 'String reference not set to an instance of a string'.  Is there anyway around this, besides explicitly excluding rows with null values in the query?

       

      Any help would be much appreciated.