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: 
Not applicable

getting error while doing incremental load

Hi Guys,

    I am loading the data from sql server,i have a field callled DOJ and the datatype is date ,that means it displays date

as yyyy-mm-dd,..while i am doing incremental load it gives me an error ..the error is operand type clash date is incompatile

with int.my script for incremental load is

IncLoad:

LOAD id,

    name,

    date(Selectdate) as Selectdate;

SQL SELECT *

FROM NORTHWND.dbo.IncTest where Selectdate>=$(vModDate);

LOAD id,

     name,

     Selectdate

FROM

(qvd) where not exists(id);

could anyone suggest me..

1 Reply
marcus_sommer

Try the variable with single-quotes: Selectdate>='$(vModDate)'

- Marcus