Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
SalesDate column is coming from database. I am trying to implement incremental load.
SalesDate values are 01SEP2016,01OCT2016, and so on.
I am using reloadtime() function.
LET lastReloadTime = num(date(ReloadTime(),'DDMMMYYYY'));
Data:
LOAD *
FROM
[..\QVD\Sales.qvd]
(qvd);
Concatenate
LOAD *;
SQL SELECT * FROM Sales_Table
where (num(date(Date#(SalesDate,'DDMMMYYYY'),'DDMMMYYYY')) > $(lastReloadTime));
Error Message:
expected something like ')' between the 'date' keyword and '('.
SQL SELECT * FROM Sales_Table
where (num(date(Date#(SalesDate,'DDMMMYYYY'),'DDMMMYYYY')) > 42647.496226852)
Please help me.
Hi
Please check below link for sample
https://sqlandplsql.com/2012/10/28/to_char-number-function-oracle/
Hi,
You can simply use
LET lastReloadTime = num(date(ReloadTime(),'DDMMMYYYY'));
TableName:
SELECT
*
FROM TableName
WHERE SalesDate > '$(lastReloadTime)';
From your Query:
SQL SELECT * FROM Sales_Table
where (num(date(Date#(SalesDate,'DDMMMYYYY'),'DDMMMYYYY')) > $(lastReloadTime));
Note: Num#(), Num(), Date#() and Date() are all qlikview functions, it won't work in SQL Queries, you can use only in LOAD statement but not in SELECT statment.
Hope this helps you.
Regards,
Jagan.