Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Appending records in Qlikview

Is it possible to append records in QlikView.

What I want to be able to do is create a QVD, then each month just add the next months data. Is there a good way to do this?

9 Replies
swuehl
MVP
MVP

Search this forum or the reference manual for incremental load using qvds. Or have a look at the nice example in the QV cookbook you can download here:

http://robwunderlich.com/downloads/

bill_mtc
Partner - Creator
Partner - Creator

Other way is to have generator which create monthly QVD and reside it in one folder/location, so that in your final script, you can simply concatenate them all...

Anonymous
Not applicable

Zagzebski

If you google QlikView Incremental Load you'll get plenty of hits.

In essence you need to:

  1. Do an initial load of your first month's data and store into a qvd.
  2. Load your next month's data
  3. Concatenate load your qvd from 1. onto your table loaded in 2. above.
  4. Save this resulting combined table into qvd.

Best Regards,     Bill

Gysbert_Wassenaar

See this discussion: Dynamic Update and Incremental Loading


talk is cheap, supply exceeds demand
zagzebski
Creator
Creator
Author

Thanks

zagzebski
Creator
Creator
Author

Thanks!

zagzebski
Creator
Creator
Author

Bill actually have a uestion for you...

1. So I create a QVD with data from Jan 2010 to Jul 2013).

2. Then the next month comes (Aug 2013) and I concatenate it into a with #1 above (so there would be 3 files?

3. Then what happens when Sept 2013 comes and I want to incrementally load?

Sorry I am a little confused.

Anonymous
Not applicable

Zagzebski

No here is what should happen

1. So I create a QVD with data from Jan 2010 to Jul 2013).

  • So you will have 1 QVD

2. Then the next month comes (Aug 2013) and I concatenate it into a with #1 above (so there would be 3 files?

  • Concatenate and store so you still have only 1 QVD

3. Then what happens when Sept 2013 comes and I want to incrementally load?

  • Concatenate and store so you still have only 1 QVD

Best Regards,    Bill

zagzebski
Creator
Creator
Author

Thanks Bill!