Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am trying to load below "load script"
but i get the following error
the date format at sql is '2018-01-01 00:00:00:000'.
can someone help with this error. What should i do?
My aim is to load only the updated rows from the sql server to qvd file.
This is the error
where DateTime > Date( >>>>>>43353<<<<<<,598842593, '')
currently as below.
SET TimestampFormat='D.MM.YYYY hh:mm:ss[.fff]';
I tried changing it qith same sql format but no luck.
Maybe we need to try changing the Last_Update_Time variable format, since the error is at that line.
Try like this
Where DateTime > Timestamp($(Last_Update_time),'YYYY-MM-DD hh:mm:ss[.fff]')
I also found this error in data manager, maybe its the reason.
Your date format issue is resolve ...for the above criteria we don't have the data I guess
From your original post and the recent one, it looks like your lib (connection) folder (or) path is missing. Please check the connection is created and pointed to the correct path to the hourly.qvd file.
Also the table name is referred as "Incremental", make sure you have not changed the table name into something else.
thanks, i deleted and re created the connection, and made sure the table name is correct.
Try
Where DateTime > DATE#($(Last_Update_time), 'YYYY-MM-DD')
Is this works now?
Below is the load script i run:
LIB CONNECT TO 'MaintenanceSQL';
URTBASE:
SQL SELECT ID,
----,
DateTime,
Referans
FROM ----."URT_BASE" where DateTime > '2018-09-01 00:00:00:000' ;
Last_Update_time:
load max(DateTime) as MaxDateTime
resident URTBASE;
Let Last_Update_time = Date(Peek('MaxDateTime',0,'Last_Update_time'), 'DD:MM:YYYY');
Drop Table URTBASE;
// Load Incremental data
Incremental:
LOAD ID,
CELLNO,
DateTime,
Referans
FROM -----."URT_BASE"
where DateTime > $(Last_Update_time);
Concatenate
Load ID,
-----,
DateTime,
Referans
From 'lib://Qlik_QVD_DATA/Hourly.qvd' (qvd);
Store Incremental into 'lib://Qlik_QVD_DATA/Hourly.qvd' (qvd);
Drop Table Incremental;
Now the error is
The following error occurred:
This statement only works with lib:// paths in this script mode
The error occurred here:
Incremental: LOAD ID, -, DateTime, Referans FROM ---.dbo."URT_BASE" where DateTime > 11:09:2018
when i change database connection from sql to Lib Folder connection this error occurs.
The following error occurred:
Unexpected token: ':', expected one of: 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', 'and', ...
The error occurred here:
Incremental: LOAD ID, ---, DateTime, Referans FROM 'lib://Qlik_QVD_DATA/Hourly.qvd' (qvd) where DateTime > 11>>>>>>:<<<<<<09:2018