qvd

[#1]

My problem:

First of all i create a QVD of a table with the whole data.

1. Know i want only the changes in a qvd à no problem

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?

[MK_QSL]

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...

[#3]

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...