topic Re: How to store dynamically changing data in QlikView

How to store dynamically changing data

dseelam — Fri, 04 Nov 2016 15:39:33 GMT

Hello All,

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

maxgro — Fri, 04 Nov 2016 21:32:55 GMT

not sure if I understand

read a qvd

add some data with a date (today) field

store in the same qvd

dseelam — Fri, 04 Nov 2016 22:00:24 GMT

max,

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 ??

maxgro — Fri, 04 Nov 2016 22:15:17 GMT

sql select * from oracletable;

let d=date(today(), 'YYYYMMDD');

store Z into Z_$(d).qvd (qvd);