topic Nested Select SQL Where Clause in QlikView

Nested Select SQL Where Clause

Tue, 11 May 2010 18:38:44 GMT

Wondering if I can do a nested select SQL statement in QLikview script... Qlikview seems grouchy though, however, I'm certain my syntax is not correct...

I have a QlikView file:TEMPFILE with only one "SchoolCode" field that contains distinct SchoolCode values.

So,

I want to LOAD new data from a database... using only data with SchoolCodes that are in the tempfile...

LOAD * From DBO.TABLENAME

WHERE SchoolCodes IN (select distinct SchoolCode from TEMPFILE)

;

What am I doing wrong?

Stephanie

Re. :Nested Select SQL Where Clause

martin59 — Tue, 11 May 2010 18:50:16 GMT

Hello Stephanie,

You can do :


TempFile:
LOAD SchoolCode FROM TempFile.xls;
Table:
LOAD * FROM DBO.TABLENAME WHERE EXISTS (SchoolCode);

Hope it's gonna be helpful.

Martin

Re. :Nested Select SQL Where Clause

martin59 — Tue, 11 May 2010 18:50:25 GMT

Hello Stephanie,

You can do :


TempFile:
LOAD SchoolCode FROM TempFile.xls;
Table:
LOAD * FROM DBO.TABLENAME WHERE EXISTS (SchoolCode);

Hope it's gonna be helpful.

Martin

Nested Select SQL Where Clause

Tue, 11 May 2010 18:51:48 GMT

Load your temp file in memory:


LOAD * FROM TEMPFILE.qvd (qvd);

After execute the SQL Statement:


LOAD * WHERE exists(SchoolCode);
SQL SELECT * FROM DBO.TABLENAME;

Nested Select SQL Where Clause

Tue, 11 May 2010 18:55:05 GMT

USE THE SQL COMMAND IN PLACE OF LOAD


SQL SELECT *
FROM DBO.TABLENAME
WHERE SCHOOLCODES IN (SELECT DISTINCT SCHOOLCODE FROM TEMPFILE)

REGARDS
TONIAL.

Nested Select SQL Where Clause

Tue, 11 May 2010 21:49:15 GMT

You folks are awesome. Thanks a bunch... I understand SQL... but mixing QlikView Scripting experience with it is where I am lacking.

Thanks again for the responses, I tried each of the methods as well.

Stephanie Lind

Nested Select SQL Where Clause

Mon, 14 May 2012 20:21:40 GMT

I like to find out how to do a IN criteria when using a qvd load or a resident load.

Thanks

Nested Select SQL Where Clause

laurens — Thu, 24 May 2012 08:40:04 GMT

Hi Jack,

With QVD load You need use the match-function.

load * from ???.qvd where match(fieldname,value1,value2,...);