Store qvd file

[Anonymous]

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,

[Anonymous]

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]

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 · Accepted solution]

I found out solution

  CONCATENATE

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

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