topic Re: How to Reduce Data on Strings only QVD in QlikView

How to Reduce Data on Strings only QVD

Fri, 17 Jul 2015 15:08:36 GMT

Hi All,

Im Sitting with a QVD that contains only ID's and Fullnames, Surnames, Country....e.t.c with no Any Date Field.

So the Question is How do i reduce that Data to be Minimal, reason Being i want to Copy the QVD, but now the Size is too Big to Copy

Almost 1.3 GB

How can i Tackle that?

Thanks.

Re: How to Reduce Data on Strings only QVD

MK_QSL — Fri, 17 Jul 2015 15:12:14 GMT

Use Key which is having unique records. May be ID

Re: How to Reduce Data on Strings only QVD

Fri, 17 Jul 2015 19:45:55 GMT

In the QVD generator QVW (the QVW which creates the QVD),

Edit Script -> Debug -> Select 'Limited Load' -> enter a small number (may be 100) -> Click Run.

Regards,

KKR

Re: How to Reduce Data on Strings only QVD

ramoncova06 — Fri, 17 Jul 2015 19:50:18 GMT

I believe Manish answer is right, if these are all unique values then it might be hard, but I would assume that you have several non unique values that could stored with an autonumber and then rejoined later on