Concatenate and store qvd file

[#1]

Hello,

I've different number of two tables in my script. The code which i'm developing for incremental package. Just i'm explain in theory as general discussion. Hope you understand.

For eg:

Table1:

Load * from

Table1

where Date >=Max(previousQvdFileDate);

Table2:

Load A,B,Count(A) as CountA from

Resident Table1

group by ID;

concatenate

Load * from

OldSummqvdFile

Store Table2 into Summarizedqvdfile;

Table3:

Load * from

OldqvdTable;

At last i want to concatenate Table1 and Table3 and it should store into qvd file.

I know for the above process i can go through the below code

Table1:

Load * from

Table1

where Date >=Max(previousQvdFileDate);

concatenate

Table3:

Load * from

OldqvdTable;

Store Table1 into qvdfile;

- But if you oberve the table2. In table2 i'm summarizing the table for latest data. After summarizing the data then only i want to create Incremental qvd file for OldqvdTable.

[pover · Accepted solution]

Would this work?

Table1:
Load * from
Table1
where Date >=Max(previousQvdFileDate);
Table2:
Load A,B,Count(A) as CountA from
Resident Table1
group by ID;
concatenate
Load * from
OldSummqvdFile;
Store Table2 into Summarizedqvdfile;
Concatenate (Table1)
Load * from
OldqvdTable;
Store Table1 into qvdfile;

Karl

[#3]

Thanks karl

But i got same solution myself. I searched in qvw help content for this and integrated in my application. Anyway thanks for your help.