Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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)
;
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,
I found out solution
CONCATENATE
LOAD DISTINCT * FROM $(vQVD)\1.qvd (QVD)
WHERE NOT EXISTS (ID) AND date(submitDateTime)>=date('$(dDate)')