Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
,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
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