Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

this is my first step in incremental load and what i have to write for second step?

here i have loaded table and generated a qvd .   now i got some updated data what i have to do for to update data

my last orderdate is

12/10/2012

pls help me

sales:

LOAD orderid,

     productid,

     customerid,

     gross_amount,

     orderDate

FROM

[..\MAPPING\2\map.xlsx],

(ooxml, embedded labels, table is sales);

store sales into $(vvpath)\sales.qvd;

6 Replies
Highlighted
MVP
MVP

Re: this is my first step in incremental load and what i have to write for second step?

Please stop posting the same question again and again.

You've already got about 10 answers to your 5-6 separate threads.

Thanks,

Stefan

Highlighted
Not applicable

Re: this is my first step in incremental load and what i have to write for second step?

sorry for that actually i did  not get proper information that time.now its little bit ok. i am new to qlikview and i am from different background thats why i have more doubts .pls excuse and qlikcommunity is my guide to learn

sorry..................................

Highlighted
MVP
MVP

Re: this is my first step in incremental load and what i have to write for second step?

Your welcome to ask, of course.

Just

- don't post multiple threads about same question, instead try to communicate your open issues in your original thread

- try to search the forum before posting, there are lots of threads that most surely already cover your topic

Just my 0.02 €

Highlighted
Not applicable

Re: this is my first step in incremental load and what i have to write for second step?

OK THANK U

Highlighted
MVP
MVP

Re: this is my first step in incremental load and what i have to write for second step?

And since you are still looking for answer to your incremental load question, I strongly suggest that you look into the QV cookbook sample file a referenced in your other thread (on Rob Wunderlich's download site).

It covers delete, update and add operations.

Highlighted
MVP & Luminary
MVP & Luminary

Re: this is my first step in incremental load and what i have to write for second step?

You may also want to see my blog post on Incremental Load, it talks around the three main types of incremental load.  There is also quite a number of comments with others adding their thoughts:

http://www.quickintelligence.co.uk/qlikview-incremental-load/

Hope that helps,

Steve