topic Dynamic Update: Save data after dynamic update in QlikView

Dynamic Update: Save data after dynamic update

Tue, 15 Apr 2014 10:46:48 GMT

Hi Experts,

I am using Dynamic Update. I have inserted two new values into my table(say, employee) how do I save it to the QVD file back from which I am reading them?

Thank you.

Re: Dynamic Update: Save data after dynamic update

its_anandrjs — Tue, 15 Apr 2014 10:56:40 GMT

As i under stand you have 2 new fields like say, employee if so then and this into the load script of the table like

tablename:

Load

say,//new field

employee, //new field

..From location;

Store tablename into tablename.qvd;

Re: Dynamic Update: Save data after dynamic update

its_anandrjs — Tue, 15 Apr 2014 10:57:35 GMT

If you provide more details then will be ok

Re: Dynamic Update: Save data after dynamic update

Tue, 15 Apr 2014 11:05:01 GMT

I have file Employee.csv, I am reading the data from it. The columns that are available are Emp Name and Emp City.

Using the below load statement I loaded the file.

Employee:

Load EmpName, //field

EmpCity, //field

From Employee.csv;

The script loaded successfully.

I have now 5 employee reocrds in the list box for name and city.

I have created two input fields, Enter New 'Emp Name' and 'Enter New Emp City'. I have 'Add' button with action Dynamic Update. The below Query I used.

INSERT INTO * (EmpName, EmpCity) VALUES ('$(vEmpName)', '$(vEmpCity)')

where vEmpName and vEmpCity variables for input boxes defined above.

When I enter a new name and city in the input text boxes and Click Add, the new values are seen in the list boxes but how do I write this new data in the source file back Employee.csv?