Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Elimination or omit duplicates

Hello everybody,

I have a QVD with data from Jan 04th 2016 until last Sunday. Since it does not make sense, to read the entire values from Jan 04th 2016 every week simply the last week is added to the existing QVD (with Concatenate command). So far so good.

Now I would like to read not only the last week, but Sunday again, because for this there are mostly still missing data, which are only gradually recorded during the week. That's why I have a lot of duplicate records that I didn't need in the QVD because this indeed falsify values.

Is it possible to detect and omit these duplicates when reading the data by the script or afterwards? And if so, how?

Thank you and best regards,

Hagen

1 Solution

Accepted Solutions
krishnacbe
Valued Contributor III

Re: Elimination or omit duplicates

Hi,

You can implement Incremental Load logic.

incremental load types

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Hope this helps

2 Replies
krishnacbe
Valued Contributor III

Re: Elimination or omit duplicates

Hi,

You can implement Incremental Load logic.

incremental load types

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Hope this helps

Not applicable

Re: Elimination or omit duplicates

That works great

Thank you!

Community Browser