Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

zagzebski
Not applicable

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?

Tags (1)
9 Replies
swuehl
Not applicable

Re: Appending records in Qlikview

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
Not applicable

Re: Appending records in Qlikview

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...

bill_markham
Not applicable

Re: Appending records in Qlikview

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
Not applicable

Re: Appending records in Qlikview

See this discussion: Dynamic Update and Incremental Loading


talk is cheap, supply exceeds demand
zagzebski
Not applicable

Re: Appending records in Qlikview

Thanks

zagzebski
Not applicable

Re: Appending records in Qlikview

Thanks!

zagzebski
Not applicable

Re: Appending records in Qlikview

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.

bill_markham
Not applicable

Re: Re: Appending records in Qlikview

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
Not applicable

Re: Re: Appending records in Qlikview

Thanks Bill!