topic Re: Import using "Where" in QlikView

Import using "Where"

Tue, 22 Oct 2013 13:22:40 GMT

I'm trying to import a very large SQL table, however I'd like to limit the results by only returning lines with fields with a certain value, in this case "T".

This is my script, but it fails I have tried variations of this but don't seem to be getting it quite right, could anyone help?

LOAD "xxACC_REF",
"xxCODE_1",
"xxDATE",
"xxVALUE";
SQL SELECT "xxACC_REF",
"xxCODE_1",
"xxDATE",
"xxVALUE",
WHERE "xxVALUE" ='T'
FROM "xxMOVEMENTS";

An example of what I would like returned: -

xxACC_REF	xxCODE_1	xxDATE	xxValue	RETURNED
1232134	123412	12/12/10	T	YES
1234234	12342134	31/05.09	C	NO
1124343	324553	14/09/02	V	NO
45346534	3532	13/06/00	T	YES

Thanks in advance

Re: Import using "Where"

javier_florian — Tue, 22 Oct 2013 13:30:40 GMT

Try with this script:

LOAD xxACC_REF,
xxCODE_1,
xxDATE,
xxVALUE;
SQL SELECT *
FROM "xxMOVEMENTS"

WHERE "xxVALUE" ='T';

Re: Import using "Where"

Peter_Cammaert — Tue, 22 Oct 2013 13:39:36 GMT

If your post contains your actual script code, you're very near to a solution:

remove the comma after your last field name in your SQL SELECT (immediately before the WHERE keyword)
put the WHERE clause BEHIND the FROM clause. You cannot reverse the order.

BTW Javier is spot on, and he was first.

Peter

Re: Import using "Where"

Tue, 22 Oct 2013 13:51:00 GMT

Thanks, I had actually just figured it out. Thanks to both of you