topic Re: Delete function in qvd in QlikView

Delete function in qvd

Fri, 24 Feb 2012 12:22:27 GMT

Hi,

What command can I use to delete a week number in a particular year from a qvd?

something like below:

Table Name:

LOAD *

FROM

test.qvd(qvd)

????????????

Where Year = '2011' and Week = '48'

;

STORE Table Name into test.qvd;

Im not sure if there is a command e.g. Delete

Thanks,

Gregg

jagan — Fri, 24 Feb 2012 12:29:36 GMT

Hi,

Try the following script

TableName:

LOAD *

FROM

test.qvd(qvd)

Where Year<> 2011 and Week <> 48;

STORE TableName into test.qvd;

Hope this helps you.

Regards,

Jagan.

Fri, 24 Feb 2012 12:34:05 GMT

Hi,

Do you know if this wont delete everything from 2011, only the week 48 from2011?

Thanks,

Gregg

jagan — Fri, 24 Feb 2012 12:37:13 GMT

Hi,

It won't delete every thing in 2011, because we used and condition for week 48. The records which has Year as 2011 and Week as 48 will be deleted.

Hope this helps you.

Regards,

jagan.