topic How to reduce data from prevously created QVD file. in QlikView

How to reduce data from prevously created QVD file.

deepakqlikview_123 — Tue, 29 Apr 2014 12:11:03 GMT

Hi Folks,

Can you please tyell me.

How to reduce data from prevously created QVD file.

Does transformation helps in this case if yes how it can help.

Thanks

Re: How to reduce data from prevously created QVD file.

DavidFoster1 — Tue, 29 Apr 2014 12:22:39 GMT

Do you mean how to read from QVDs and not return all the rows?

Re: How to reduce data from prevously created QVD file.

sudeepkm — Tue, 29 Apr 2014 12:26:37 GMT

when you load data from QVD you can use the where clause to restrict what data you want to load.

Most of the time the QVD load where clause have time related restriction. for example you have QVD generation incremental and it only hold past 12 months data so each month automatically when you load data from QVD you can use the where clause to restrict to past 12 months only.

Re: How to reduce data from prevously created QVD file.

DavidFoster1 — Tue, 29 Apr 2014 12:30:14 GMT

A trick I use to allow the QVD load to remain optimised is to load an inline table with the list of values I want to return data for (a specif region, a set of dates, etc, etc) and then I can use 'WHERE EXISTS' syntax which is permitted in optimised loads.

Re: How to reduce data from prevously created QVD file.

deepakqlikview_123 — Tue, 29 Apr 2014 16:16:09 GMT

while generating qvd is is possible if i want records only after year 2012.then is is possible to reduce number of records.

Thanks

Re: How to reduce data from prevously created QVD file.

tresB — Tue, 29 Apr 2014 16:19:22 GMT

Have you tried simple where clause like:

NewTable:

Load

Year,

OtherField

From <OldQvd> Where Year>2012;

Store NewTable into <>;