Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Store qvd file

Hi guys,

Please help me with store qvd file.

I load 1 file, then

  CONCATENATE

LOAD DISTINCT * FROM $(vQVD)\NEWFILE.qvd (QVD) ;

  where date(submitDateTime)>=date('$(dDate)');           -cut 6 months

I need to store them in 1 file.

  STORE MYFILE INTO $(vQVD)\NEWFILE.qvd (QVD);

Other words, I replace old MYFILE to a new. (6 last months + current month)

Thank you,

12 Replies
Anonymous
Not applicable
Author

If the rows have a unique key, use that key to filter out the duplicates . . .

We joined some columns to one field as a key field . . . then you got something like this:

CONCATENATE (ResponseTimes)

LOAD *

FROM $(vDirectory)\ResponseTimes.qvd (qvd)

WHERE NOT EXISTS(ResponseTimes.ResponseKey)

;

Anonymous
Not applicable
Author

Please help me with script

  I load current month in a script, then concatenate with historical data.

  I use many qvw files which load the same qvd file.  I get double count for CURRENT month. How can I fix that?

  CONCATENATE

  LOAD DISTINCT * FROM $(vQVD)\1.qvd (QVD)

WHERE NOT EXISTS (MYear) AND date(submitDateTime)>=date('$(dDate)') 

Thanks,

Anonymous
Not applicable
Author

I found out solution

  CONCATENATE

  LOAD DISTINCT * FROM $(vQVD)\1.qvd (QVD)

WHERE NOT EXISTS (ID) AND date(submitDateTime)>=date('$(dDate)')