Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Need help to do inc load

Hi all, @sunny_talwar 

 

i have data like attached  . i want to incremental load  in Qlikview  with this   data

 

Day is the date field  how to do this?

thanks

sony

Labels (2)
5 Replies
avinashelite

I saw your data set, I have few queries
1.Everyday you will get years of years date value?
2.If yes, will their be any changes to the old records?
3.If you dont have update date column or lastest change columns try to base the incremental logic on primary key
Vegar
MVP
MVP

Incremental loads can be done in multiple ways depending on how data is updated and the needs of the business.

Here is a simple approach fetching all new rows based on the Day field.

I assume you have an inc_data.qvd with previous loaded data.


inc_data:
Load *
From inc_data.qvd (qvd);

TmpMaxDay:
LOAD Max(Day) as MaxDay;
LOAD FieldValue('Day', recno()) as Day
AUTOGENERATE FieldValueCount('Day');
Let vMaxDay = peek('MaxDay',-1,'TmpMaxDay')

Concatenate (inc_data)
Load * from DataSource
Where Day > $(vMaxDay);

Store inc_data into inc_data.qvd (qvd);
soniasweety
Master
Master
Author

Hi @Vegar   

 

im getting general error

 

attached is the error,

Vegar
MVP
MVP

It looks like I wrote the apostrophes with the wrong format. I've adjusted my earlier post with the right format.

Copy it again and retry
soniasweety
Master
Master
Author

yeah its reloaded. thank you

let me check with my live data and come back