Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

BUFFER LOAD - right parenthesis is missing

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

1 Reply
erichshiino
Partner - Master
Partner - Master

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