topic Same table update the values in QlikView

Same table update the values

sathishkumar_go — Fri, 05 Mar 2010 09:55:27 GMT

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

Same table update the values

Fri, 05 Mar 2010 11:33:50 GMT

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

Same table update the values

sathishkumar_go — Fri, 05 Mar 2010 13:11:57 GMT

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