Need help to do inc load

[soniasweety]

Hi all, @sunny_talwar 

kaushik_solanki

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

[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]

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]

Hi @Vegar   

im getting general error

attached is the error,

[Vegar]

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]

yeah its reloaded. thank you

let me check with my live data and come back