Import using "Where"

[#1]

Hi

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

[javier_florian · Accepted solution]

Try with this script:

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

WHERE "xxVALUE" ='T';

[Peter_Cammaert]

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

[#4]

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