Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
//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;
//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;
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.