Discussion Board for collaboration related to QlikView App Development.
This is kind of best practice question and please give example.
If you have process running on server that generates new qvd and then another one that actually takes that newly generated qvd and merges with exisitng qvd.
1) how do you setup code to do auto update everyday.
2) I know the part on how to schedule 2 qvw to run on qmc task manager.
Please share an example
This is a concept of incremental load.
Load * from <Table>
where date(update_date) >= date(today()-1) ; // Any condition which is used to generate new qvd daily.
Store Daily_new into Daily_new.qvd;
drop table Daily_new;
Load * from original.qvd(qvd);
Load * from Daily_new.qvd(qvd) ;
Store Original into Original.qvd;
In this way you can actually merge your new data to the previous one, and hence no multiple qvws will be required.
Hope this helps.
How do you create data part automatically for each day so that you don't have to manage it.
Can you please provide you script ,
so that I can explain it to you in a much better way.