topic Re: BUFFER LOAD - right parenthesis is missing in QlikView

BUFFER LOAD - right parenthesis is missing

helen_pip — Tue, 06 Nov 2012 09:38:21 GMT

Hello,

Could someone kindly help me with why my LOAD is not working correctly

I get an error message of: right parenthesis is missing

current_breeches:

BUFFER(Stale after 1 hour) LOAD

attendance_id

,
attendance_arrivaldate,
Breach_Location,
cat_currentlocid,
end_date,
waiting_time,
Breaches;
SELECT * FROM C:\QLIKVIEW\DEVELOPMENT\HP\QVD\CURRENT_BREACHES.qvd
(qvd);

Also if I take the buffer load statement out my QVD brings through old data and does not refresh itself

Any ideas?

Kind Regards

Helen

Re: BUFFER LOAD - right parenthesis is missing

erichshiino — Tue, 06 Nov 2012 14:40:37 GMT

Hi, Helen

I did the following script ( which is similar and it worked)

buffer (stale after 7 days)

Test:

LOAD *

FROM

Template.xlsx

(ooxml, embedded labels, table is X);

Maybe it will work if you simplify the code like this:

current_breeches:

BUFFER(Stale after 1 hour) LOAD

attendance_id

,
attendance_arrivaldate,
Breach_Location,
cat_currentlocid,
end_date,
waiting_time,
Breaches
FROM C:\QLIKVIEW\DEVELOPMENT\HP\QVD\CURRENT_BREACHES.qvd
(qvd);

Hope it helps,

Erich