Data loaded twice in QVD

[master_student]

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 

[Kushal_Chawda · Accepted solution]

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

[PrashantSangle]

Hi,

use distinct  keyword in script.

Regards,

[andrespa]

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

Best regards,

Adnrés

[Peter_Cammaert]

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

[master_student]

the fiels date is the field date in my qvw?

Thanks

[master_student]

yes, they are exactly the same..

[PrashantSangle]

while loading it in qvd you can try with distinct keyword

like

select distinct * from tableName

Regards,

[Kushal_Chawda]

Yeah,It's Date field in your QVW

[master_student]

Thanks Andres for your reply. The pb was fixed.