topic Incremental Load for QVD in QlikView

Incremental Load for QVD

Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I am currently creating a QVD.

and I want one row added for each day

my QVD looks like this at the moment

date	cal1	col2	col3	col4

so, when the script is run, each day, the col 1 to 4 will have different values and date also.

I can set this up to run each day and I don't want existing value to be updated but just have a row for each date.

I don't want previous data to be interrupted.

and date is set to be date(today())

How can I do this???

Please help me

Thank you

adamdavi3s — Tue, 06 Dec 2016 10:52:03 GMT

I think we need to know a little more about what you are loading and where from?

But in general you just load today's data, concatenate the load from the QVD and then re-save the QVD and that should work?

Assuming that in your load script you just set the date = date(today()) and you only load it once a day then you should be fine?

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.