Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My problem:
First of all i create a QVD of a table with the whole data.
I want to name the changed qvd Tablename -20140617
This qvd is genearted every day how can i create the name with the actual Date
Like Tablename -20140617
Tablename- 20140618
…..
The second problem is to create a new qvd with the old big data and the changed lines
There is a field who said me which line is changed…
How can i make it with a script in a qvw?
Create a variable for date and add with QVD storing function...something like below
Let vDate = Date(Date#(Today(),'DD/MM/YYYY'),'DDMMYYYY');
Sales:
Load * Inline
[
Customer, Sales
A, 100
B, 120
];
Store Sales into Sales$(vDate).qvd(qvd);
For 2nd Question,, you need to use incremental load.. It's a big topic and you can search from Community...
Do one thing take a variable & set it to date format whatever you want, & when you are going to save qvd use that variable as qvd name...