Appending records in Qlikview

[zagzebski]

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?

[swuehl]

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]

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]

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

[zagzebski]

Thanks

[zagzebski]

Thanks!

[zagzebski]

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]

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]

Thanks Bill!