Discussion Board for collaboration on QlikView Scripting.
Is it possible to store history of dynamically changing data every day in the form of single QVD
if the above is not possible how to store dynamically changing data in the form of different QVD's one for each day and store in single folder ??
Is it make sense to use incremental loading for dynamic data ?
Thanks in advance
not sure if I understand
read a qvd
add some data with a date (today) field
store in the same qvd
I am loading data from oracle every day which is dynamically changing, How can I search history in this case
so I want to store every day load as a single QVD with date as a QVD name
is it possible ??
sql select * from oracletable;
let d=date(today(), 'YYYYMMDD');
store Z into Z_$(d).qvd (qvd);