where clause in QVD load

[#1]

Hi,

Any idea why this script is ignoring the Where clause?  It should only load records where STATE = 'CA', but it just loads everything. 

LOAD [First Name],

     [Last Name],

     State,

     Title,

     Company,

     ActivityDate

FROM

(qvd)

WHERE(State = 'CA');

Thanks

[colinh]

Try it without the brackets:  WHERE State = 'CA';

[#3]

Check for the Space in Data

you can use trim function

LOAD [First Name],

     [Last Name],

     State,

     Title,

     Company,

     ActivityDate

FROM

(qvd)

Where trim(State) = 'CA';

[#4]

I tried Trim and I tried removing the brackets.  No better.  The original code was actually generated with the load wizard, incidentally.

[colinh]

In your data is the value 'ca' or 'CA'?  Try where upper(State) = 'CA';

[#6]

There are lots of different values but definitely some having CA.  But my problem is that all data gets loaded, not that some are being wrongly excluded.

FYI, I originally was trying to select on a numeric value but the Where clause didn't work for that one either.

[colinh]

Very odd.  Using the wizard to create an almost identical statement works fine for me.

What version / service release of QlikView are you using?

[#8]

Yes, agree it's weird.  Either something in my data or there's a higher level setting someplace.  But I haven't changed any defaults.

If it matters, I'm running Windows 7 64 bit, and running QV 10.00.8815.6 SR1 64-bit.  Maybe I'll try downloading some patches.

[colinh]

SR1 was, in my very short experience with it, very buggy.  I would upgrade to SR3 and see if that fixes the problem.

[#10]

No, SR3 didn't fix it.  Don't understand.  Seems so simple.