Using WHERE in LOAD

[#1]

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

[#2 · Accepted solution]

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';

[#3]

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