topic Using WHERE in LOAD in QlikView

Using WHERE in LOAD

Wed, 25 May 2011 09:40:43 GMT

Hello,

I'd like some help on how to create a where clause in the load so I dont have to load all the old redundant data

SQL SELECT * FROM G_Ldatabase.dbo."G_L Entry" WHERE 'Posting Date' > '01/08/2005';

sorry if this seems a simple question I am just figuring out qlikview

Thank you for your time it's much appreciated

Wed, 25 May 2011 09:47:26 GMT

Try this:

Test:

LOAD

PostingDate,

DTEISS,

DATERETN,

TERMID,

"USER",

"TRANSACTION_DATE",

"TRANSACTION_TIME",

"USER_PROFILE",

"JOB_NAME",

DATIME;

SQL SELECT *

FROM B005592P.ITGDTA.COINPF

where PostingDate > '01/08/2005';

Wed, 25 May 2011 09:59:23 GMT

Thanks for that. I relised that posting date was suppose to have speach marks as it was two words