topic Re: Update QVD Data with New One in QlikView

Update QVD Data with New One

Anonymous — Tue, 06 Oct 2015 11:18:07 GMT

Hi I have a question about updating qvd data.

First, i've load the data from SourceA,

The data is like this:

Name LastName Qty

A AB 5

I Store that table into Data.QVD

Another week i have another data Source lets say SourceB

The data is like this:

Name LastName Qty

A AB 10

i want to update Data.QVD , so the Qty data will be update from 5 to 10

Is it possible to make it ?

I have try using concatenate, but it keep both data (data with qty 5 and data with qty10)

The result i expect is Data.QVD will have data like this:

Name LastName Qty

A AB 10

Thanks in advance

Re: Update QVD Data with New One

Peter_Cammaert — Tue, 06 Oct 2015 12:24:00 GMT

You'll need some sort of primary key (an id that uniquely identifies each row) and the exists() function to accomplish this. Imagine that Name & LastName can be considered your primary key, then you can go ahead as follows:

NewData: // Load new & updated records

LOAD Name, LastName, Qty, Name & '|' & LastName AS PK

FROM SourceB (options);

CONCATENATE // Add historical records that haven't been updated

LOAD Name, LastName, Qty

FROM SourceA (options)

WHERE Not Exists(PK, Name & '|' & LastName);

DROP Field PK;

This is more or less the basic technique to perform a so-called Incremental Load;

Best,

Peter

Re: Update QVD Data with New One

gautik92 — Tue, 06 Oct 2015 12:24:56 GMT

use incremental load

Re: Update QVD Data with New One

senpradip007 — Tue, 06 Oct 2015 12:27:37 GMT

Data:

load * inline [

Name, LastName, Qty

A, AB, 5

];

Store Data into Data.qvd(qvd);

Data:

NoConcatenate

load * inline [

Name, LastName, Qty

A, AB, 10

];

Store Data into Data.qvd(qvd);

Try like this.

Re: Update QVD Data with New One

sunny_talwar — Tue, 06 Oct 2015 12:28:59 GMT

I think you need to look at incremental load which allows for deleting and updating records. May be check these links out:

HTH

Best,

Sunny

Re: Update QVD Data with New One

Anonymous — Wed, 07 Oct 2015 01:00:48 GMT

Hi all,

Thanks for your response.

It solve my problem perfectly.

Thanks in advance

Re: Update QVD Data with New One

Anonymous — Wed, 07 Oct 2015 01:01:57 GMT

Hi Peter,

Your idea is perfect !

Thanks in advance