Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sanjeeva_279
New Contributor

Incremental load implement

Hi I am trying to implement incremental load for one of my dashbaord

 

issues : DATE' is not a recognized built-in function name/date is not comparable with INT 

i have loaded tables data in qvd and identified date field ,date field i am using it as variable max(datefield) for max date data

 

when i am trying to concatenate data i am having issues with date and int issues

 

QVD: name,date,salary     ---date as field for date  max(date) as maxdate

Incremental : 

select name ,date,salary from table employee  where date > maxdate;

concatenate

 

load  name,date,salary from qvd;

 

in this scenario i am getting date issues as maxdate and date field is not compatable  etc...

 

 

Labels (1)
1 Reply
asinha1991
Contributor

Re: Incremental load implement

is the select query running fine?