Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pgarcia75
Contributor III
Contributor III

problem to load data in script for on deux rolling year

Hello

I want to load datas contained in an ORACLE table database with a loading script on  2 rolling years


I tried this script:


LOAD
         date (DATETPT) as DATETPT_DTI, // Date of request
         REFDTI, // Unique number ref request (link to the table
...
SQL SELECT *
FROM PTAH.PCADTI WHERE PTAH.DATETPT <NOW () AND PTAH.DATETPT> DATE_SUB (NOW (), INTERVAL 2 YEAR);


When I start loading, I have a SQL error that tells me a bracket error on the right

PS:
The statement (without the WHERE clause) works


Thanks for your help


PATRICE


1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try replacing NOW() with SYSDATE or with CURRENT_DATE. Now() is a Qlikview function, which oracle doesn't understand.


talk is cheap, supply exceeds demand