Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Please stop posting the same question again and again.
You've already got about 10 answers to your 5-6 separate threads.
Thanks,
Stefan
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..................................
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 €
OK THANK U
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.
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