Can QVD gets the Updated Values?

[Anil_Babu_Samineni]

Hello,

I just created one inline

Sales:

LOAD * INLINE [

ID, Name, Sales

1, Anil, 10

2, Babu, 20

3, Samineni, 30

];

STORE Sales into Z:\qvd (qvd);

Then Table box looking like this

Now, What i want to achieve is I want to Update Value Where Name = 'Samineni' - Sales = '40'

This should achieve from after deleting inline and STORE Command

For getting we just load that into Qlikview

LOAD * from Z:\qvd (qvd);

After I've tried like below

LOAD * from Z:\qvd (qvd); Where if(ID=2,'Babu1',if(ID=3,'Samineni1',Name));

It is not working, Can anyone assist me, Please???

[Anonymous]

Hi Anil,

For getting the updates in QVD, u need to perform an incremental load.

Check out this link on how to do this.

Incremental Load in QlikView – Part1 – Learn QlikView

Thanks.

[sunny_talwar · Accepted solution]

I am not sure I understand your intent, but may be this:

Sales:

LOAD * INLINE [

ID, Name, Sales

1, Anil, 10

2, Babu, 20

3, Samineni, 30

];

STORE Sales into Sales.qvd (qvd);

DROP Table Sales;

Sales:

LOAD ID,

  Name,

  If(Name = 'Samineni', 40, Sales) as Sales

From Sales.qvd (qvd);

STORE Sales into Sales.qvd (qvd);

[Anil_Babu_Samineni]

Sunny, I am able to try to get from after loading the qvd only

LOAD * from Z:\qvd (qvd);

I have this, From this how to get Update without Increment Load. is that, Possible. Sometimes we need to change 100 Records then we can update using Increment load. My target is Without increment load.

Is that possible?

[Anil_Babu_Samineni]

With incremental list we can use all operation like dml. But, my question if without that is that it's possible