Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Reduce Data on Strings only QVD

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.

3 Replies
MK_QSL
MVP
MVP

Use Key which is having unique records. May be ID

Not applicable
Author

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

ramoncova06
Partner - Specialist III
Partner - Specialist III

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