Qlik Sense Clould LOAD SELECT and WHERE

[Adamo]

Hi,

Whenever I Use Google Sheets Connector on QLIK SENSE BUSINESS  (Cloud) it inserts a SCRIPT using the SELECT statement.

I have two questions about it.

1. Is there a way to write that code without using the SELECT statement that is duplicating the amount of Text as It´s writing twice my variables.

2. How do I say to this script that do not load     where Check Tipo is not 'Buzoneo Masivo' I have tried to put that in several parts of the code but I am not able.  

    WHERE [Check Tipo] <>'Buzoneo Masivo'

LIB CONNECT TO 'Google_Drive_&_Spreadsheets - luis.carmona@adamo.es';
ONLINE_OFFLINE:

LOAD
       Fecha,
	Tipo,
	[Check Tipo],
	Cantidad,
	[Población];



SELECT Fecha,
	Tipo,
	[Check Tipo],
	Cantidad,
	[Población]

FROM GetWorksheet
WITH PROPERTIES (
worksheetKey='1BM3pUrAX3ILYtqUPo4Ja2YuSV6F1z_0uXbcNvRGZDXM:_998639052',
gidOverride='',
generatedNumberedColumns='false',
skipRows=''
) ;

[Stoyan_Terziev · Accepted solution]

Hi,

On Q 1 - basically you cannot. The select statement is basically the script QS uses to fetch the data from the DB. Technically you can remove the LOAD statement instead, but you should rather not - it will come in use once you want to apply QS-specific transformation scripts on the data attributes.

On Q2 - you are saying " do not load where Check Tipo is not 'Buzoneo Masivo'". This basically means "Load only 'Buzoneo Masivo'". But instead I've set it to exclude this value:

LIB CONNECT TO 'Google_Drive_&_Spreadsheets - luis.carmona@adamo.es';
ONLINE_OFFLINE:

LOAD
       Fecha,
	Tipo,
	[Check Tipo],
	Cantidad,
	[Población]
WHERE [Check Tipo]<>'Buzoneo Masivo'
;
SELECT Fecha,
	Tipo,
	[Check Tipo],
	Cantidad,
	[Población]

FROM GetWorksheet
WITH PROPERTIES (
worksheetKey='1BM3pUrAX3ILYtqUPo4Ja2YuSV6F1z_0uXbcNvRGZDXM:_998639052',
gidOverride='',
generatedNumberedColumns='false',
skipRows=''
) ;