topic Can QVD gets the Updated Values? in QlikView

Can QVD gets the Updated Values?

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

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???

Re: Can QVD gets the Updated Values?

Anonymous — Sat, 10 Sep 2016 11:55:49 GMT

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.

Re: Can QVD gets the Updated Values?

sunny_talwar — Sat, 10 Sep 2016 13:00:12 GMT

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);

Re: Can QVD gets the Updated Values?

Anil_Babu_Samineni — Sat, 10 Sep 2016 17:25:21 GMT

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?

Re: Can QVD gets the Updated Values?

Anil_Babu_Samineni — Sun, 11 Sep 2016 04:33:05 GMT

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