How to add New Data into Stored QVD's

[kushalthakral]

Hi all

i am using script like

Tab:

Load

A,

B,

C,

D,

Month(Today()) as Month,

Year(Today()) as Year;

Store * from Tab into Tab.qvd;

drop Table Tab;

Now every month i want to run this script but do not overwrite the existing data but to append in the old data

How to achieve this.

Thanks

Kushal

[MK_QSL]

Do Incremental Load...

Search on this community, you will find 100's of questions-answers.

[its_anandrjs]

Use Incremental load with the RowNo() function for the appending to old data and do follow incremental loads manuals for incremental loads.

[kushalthakral]

Hi all

Can you please share script for the same.

As i have never done incremental before.

Thanks

Kushal

[#5 · Accepted solution]

Tab:

load

*

from [Tab.qvd.]

concatenate

Load

A,

B,

C,

D,

Month(Today()) as Month,

Year(Today()) as Year;

Store * from Tab

[Anonymous]

If you want add any new data to already existed old QVD created before ,for that u have to do INCREMENTAL LODE(it will added new data to the old existed Qvd) and it wnt effect the data while loding also but we have to fallow some rules to do incremental lode

[its_anandrjs]

Follow this documents

Re: Incremental load for Updation

[Anonymous]

If you want to load all of A, B, C etc every time and append it, do as Magdalena said. If you want only new/changed records appended, search incremental load. Not clear from your post what result you actually want to achieve.

[its_anandrjs]

Look small example

TableA:

LOAD RowNo() AS rid,ColA;

LOAD * Inline

[

ColA

A

B

C

D

];

STORE TableA into TableA.qvd;

DROP Table TableA;

NoConcatenate

TableA:

LOAD rid,

     ColA

FROM

A.qvd

(qvd);

Concatenate

LOAD RowNo() AS rid,ColA;

LOAD * Inline

[

ColA

A

B

C

D

];

STORE TableA into TableA.qvd;

You can use Where Exits functions also.

[kushalthakral]

Thank you All

Regards

Kushal Thakral