topic How to update Data Tables Partially in QlikView

How to update Data Tables Partially

Wed, 13 Jan 2010 06:19:55 GMT

Dear All,

I have a customer information table. Is there any easy way to update each cutomer's personal information such as mailing address, telephone number, marriage status, and etc.?

Say, there are customers named A, B, C, D, E, F,,,,,,,. When I want to update the personal information of only customer B, do I have to load and update all of the information table again? But it's going to take much time when the volume of the information is huge and the update is necessary many times.

Hope someone can help me....

Many Thanks in Advance.

How to update Data Tables Partially

Fri, 15 Jan 2010 12:21:57 GMT

Does anyone have any good solutions? I'm so troubled.....

How to update Data Tables Partially

Fri, 15 Jan 2010 12:43:26 GMT

Hi,

You can make all those fields that you want to be able to edit input fields. You should list them using inputfield statement in the script before they appear in a load or select statement.

The syntax is

inputfield ListOfFields

where ListofFields is one or more field names separated by commas.

Examples:

Inputfield B;
Inputfield A,B;
Inputfield B??x*;

Those are from the reference manual 🙂

Hope this helps!

How to update Data Tables Partially

Fri, 15 Jan 2010 13:24:49 GMT

Hi,

first of all: do you have a modification flag identifying the modified records?

If so the steps are as follows.

- Initial LOAD and and save the table as qvd file.

- use the modification flag and read modified records at a later time

- load your qvd file and concatenate the modified records

See the attached example for more details.

See also QV Help: Using QVD files for incremental load

Another question are: do you want to have the old and modified records in your application (for historical annalysis)?

AND KEP IN MIND: it´s only an example/idea how it could work

Hope it helps to solve your problem.

Good luck!

Rainer