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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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