Same table update the values

[sathishkumar_go]

Hi All,

In my data they have 3 fields

Year Period Value

2010 1 12345

in this table i converted into qvd. but my problem is, In this table Client ll update the values for 2nd period instead of 1st period. they don't maintain 2nd row. so when i am reloading qvd i lost the data for period 1. but i want period 1 and 2 values.

Hope u ll understand my problem. Looking forward ur reply!!!!!!!!!!!

-Sathish

[#2]

Hi Sathish,

One approach would be pulling the data from DB and converting that in to Qvd and drop the table and comment the code. Again pull the data from same QVD and pull the data from DB and concatenate the data which is been pulled from DB to the QVD and create a new with the Same QVD name.

Your code should be as follows.

/* This below Process has to be Followed only at 1st time

[Table A]:

Load * From XXXX.A; // Data from DB

Store [Table A] into D:/QVD/Table A;

Drop Table [Table A];

*/

//This below Process has to be Followed from 2nd time load

[Table A]:

Load * From Table A (QVD); // Load Data from QVD

Concatenate

Load * From XXXX.A; // Data from DB

Store [Table A] into D:/QVD/Table A;

Drop table [Table A];

Hope this will help you.

Rgdrs

Sridhar

[sathishkumar_go]

Ya sri

but when we finish the project. we put schedulre and batch file. because this is month wise they ll enter. month wise they ll update. for going forward (means after finishing this project also) it won't work na??

-Sathish