Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremantal load QVW from source and from QVD

Hi,

Can someone explain me very simple how i do incremental load from source and from QVD?

So i load data from my source into qvw - I wanna do this incremental by a datefield

I then save this data in a QVD file

then i  make a new QVW which load incremental from QVD - How can i do that?

Thank you!

1 Solution

Accepted Solutions
Not applicable
Author

 

//Main:
//LOAD Date,
//EmpName,
//Sal
//FROM SourceFile;

//STORE Main into Main.qvd;


Main:
LOAD Max(Date,'DD/MM/YYYY') as MaxDate
FROM
Main.qvd;

Let vMaxDate = Peek('MaxDate',-1,Main);

Drop Table Main;

Main:
LOAD Date,
EmpName,
Sal
FROM
Main.qvd;


Concatenate

LOAD Date,
EmpName,
Sal
FROM SourceFile

Where Date>$(vMaxDate );

STORE Main into Main.qvd;

View solution in original post

2 Replies
Not applicable
Author

 

//Main:
//LOAD Date,
//EmpName,
//Sal
//FROM SourceFile;

//STORE Main into Main.qvd;


Main:
LOAD Max(Date,'DD/MM/YYYY') as MaxDate
FROM
Main.qvd;

Let vMaxDate = Peek('MaxDate',-1,Main);

Drop Table Main;

Main:
LOAD Date,
EmpName,
Sal
FROM
Main.qvd;


Concatenate

LOAD Date,
EmpName,
Sal
FROM SourceFile

Where Date>$(vMaxDate );

STORE Main into Main.qvd;

senpradip007
Specialist III
Specialist III

Hi.

First you check the max date of the existing QVD and then load the data from the source with this date.

Now you can concatenate the new data with the existing to your QVW.