Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try it without the brackets: WHERE State = 'CA';
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';
I tried Trim and I tried removing the brackets. No better. The original code was actually generated with the load wizard, incidentally.
In your data is the value 'ca' or 'CA'? Try where upper(State) = 'CA';
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.
Very odd. Using the wizard to create an almost identical statement works fine for me.
What version / service release of QlikView are you using?
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.
SR1 was, in my very short experience with it, very buggy. I would upgrade to SR3 and see if that fixes the problem.
No, SR3 didn't fix it. Don't understand. Seems so simple.