Change value in QVD file

[#1]

Hi,

I have qvd file with lots of data.

Please see below first two rows have wrong Net Qty. now I want to set this Net Qty = 1

How can I change in QVD file only those values?

[mvanlutterveld · Accepted solution]

Hi

Assuming that INVO is the unique ID for the records in your QVD, you can do the following while loading the QVD:

If(INVO = '08237034' or INVO = '08283911',1,NetQty) as NetQty.

After that store the QVD.

Cheers,

Michiel

[Anonymous]

Vinay

Write a quick qw to load the qvd, with an IF to mend your data, then store it into a qvd.

[Or use a 3rd party tool to edit the qvd, as long as your faith in the integrity of the tool]

Best Regards,     Bill

[alexandros17]

If The key for your qvd file is for example username then

Load

if(username = 'username_to_change_value', newval, oldval) as field_to_change

fld1,

fld2,

...

from qvd

Hope it helps

[Clever_Anjos]

You can´t change a QVD, only rewrite than

Create an empty aplication implementing a a IF logic to fix the value

Store the values to a new qvd

[its_anandrjs]

Hi,

On existing QVD you are not able to change those data but you are able to create another QVD without loading those data for '08237034' or '08283911' and create another QVD other wise on dashboard you are able to show 1 for those IDs.

HTH

Thanks & Regards

[#7]

Thanks Michiel,

I have used if like ... and it working fine. thanks again.

accpg_accno,
accpg_opr,
accpg_ordtyp,
accpg_pno,
Branch,
[Branch Name],
DECDDT,
DECDDT1,
username,
usertype,
IVNO,
if((Branch = '127' And IVNO = '08283911') or (Branch = '123' And IVNO = '08237034') , 1, [Net Qty]) as [Net Qty],
[Net Sales]
FROM
(qvd);

[#8]

Hi, I was also having many queries during the course of my learning, but found this informative tutorial http://www.youtube.com/watch?v=8olMt2AOUJ8 . Perfect tutorial for me, just right. Most certainly recommend this course to others.

[#9]

Thanks. I will watch definitely.