topic Re: Data loaded twice in QVD in QlikView

Data loaded twice in QVD

master_student — Wed, 25 Nov 2020 16:16:04 GMT

Hello my dear community,

A question, I loaded the data of my qvw twice in my QVD, data of the date of 23/05/2016.

Coud you please advise on how to remove the data of that day?

Thanks a lot

Re: Data loaded twice in QVD

Kushal_Chawda — Fri, 27 May 2016 08:59:39 GMT

Date:

LOAD * inline [

DateExclude

23/05/2016 ];

// Remove data for this date and store the data again in the same QVD

Data:

LOAD *

FROM Data.qvd(qvd)

WHERE not exists (DateExclude,Date);

Store Data into ..\Data.qvd;

Note: date format of DateExclude,Date should be the same

Re: Data loaded twice in QVD

PrashantSangle — Fri, 27 May 2016 09:00:31 GMT

Hi,

use distinct keyword in script.

Regards,

Re: Data loaded twice in QVD

andrespa — Fri, 27 May 2016 09:01:02 GMT

Hi, could you post some sample data? To fully understand your requirement.

Best regards,

Adnrés

Re: Data loaded twice in QVD

Peter_Cammaert — Fri, 27 May 2016 09:40:29 GMT

AFAIK by not storing the data twice in your QVD in the first place.

Are those double rows exactly the same? Storing data twice (without a need for it) and then again trying to eliminate the excess rows is a double waste of time. Data sets will only grow, and in the end you may face problems with reload jobs taking too long to complete for no apparent reason.

Peter

Re: Data loaded twice in QVD

master_student — Fri, 27 May 2016 09:54:08 GMT

the fiels date is the field date in my qvw?

Thanks

Re: Data loaded twice in QVD

master_student — Fri, 27 May 2016 09:55:06 GMT

yes, they are exactly the same..

Re: Data loaded twice in QVD

PrashantSangle — Fri, 27 May 2016 09:57:54 GMT

while loading it in qvd you can try with distinct keyword

select distinct * from tableName

Regards,

Re: Data loaded twice in QVD

Kushal_Chawda — Fri, 27 May 2016 09:58:05 GMT

Yeah,It's Date field in your QVW

Re: Data loaded twice in QVD

master_student — Fri, 27 May 2016 10:51:30 GMT

Thanks Andres for your reply. The pb was fixed.