topic Re: BigQuery connector: String reference not set to an instance of a string in QlikView https://community.qlik.com/t5/QlikView/BigQuery-connector-String-reference-not-set-to-an-instance-of-a/m-p/554471#M692937 <HTML><HEAD></HEAD><BODY><P>Hi i Know this is an old thread but i am surprised no one else is experiancing this issue. when tested with the qvsource (BETA) big query connector all worked well with null values. though it does look like this connector has issues. can we confirm if there is still a bug.</P><P></P><P>we are trying to load GA anayltics data through big query. it works when a not null field set is collected but we cannot select all fields?.</P></BODY></HTML> Thu, 26 Jun 2014 05:44:17 GMT 2014-06-26T05:44:17Z BigQuery connector: String reference not set to an instance of a string https://community.qlik.com/t5/QlikView/BigQuery-connector-String-reference-not-set-to-an-instance-of-a/m-p/554470#M692936 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I've been using Qlikview's BigQuery connector to retrieve data from tables in bigquery datasets.</P><P></P><P>Here's a very simple sample query:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13754556639987161" jivemacro_uid="_13754556639987161"><P class="p1"><SPAN class="s1">CUSTOM</SPAN><SPAN class="s2"> </SPAN><SPAN class="s1"><STRONG>CONNECT</STRONG></SPAN><SPAN class="s2"> </SPAN><SPAN class="s1">TO...</SPAN><SPAN class="s2"><BR /> <BR /> tableA:</SPAN><SPAN class="s2"><BR /> </SPAN><SPAN class="s1"><STRONG>SQL</STRONG></SPAN><SPAN class="s2"> SELECT *<BR /> <BR /> FROM tableA; </SPAN></P><P></P></PRE><P></P><P>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'.&nbsp; Is there anyway around this, besides explicitly excluding rows with null values in the query?</P><P></P><P>Any help would be much appreciated.</P></BODY></HTML> Fri, 02 Aug 2013 15:04:21 GMT https://community.qlik.com/t5/QlikView/BigQuery-connector-String-reference-not-set-to-an-instance-of-a/m-p/554470#M692936 2013-08-02T15:04:21Z Re: BigQuery connector: String reference not set to an instance of a string https://community.qlik.com/t5/QlikView/BigQuery-connector-String-reference-not-set-to-an-instance-of-a/m-p/554471#M692937 <HTML><HEAD></HEAD><BODY><P>Hi i Know this is an old thread but i am surprised no one else is experiancing this issue. when tested with the qvsource (BETA) big query connector all worked well with null values. though it does look like this connector has issues. can we confirm if there is still a bug.</P><P></P><P>we are trying to load GA anayltics data through big query. it works when a not null field set is collected but we cannot select all fields?.</P></BODY></HTML> Thu, 26 Jun 2014 05:44:17 GMT https://community.qlik.com/t5/QlikView/BigQuery-connector-String-reference-not-set-to-an-instance-of-a/m-p/554471#M692937 2014-06-26T05:44:17Z