Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dseelam
Contributor

How to store dynamically changing data

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

3 Replies
MVP
MVP

Re: How to store dynamically changing data

not sure if I understand

read a qvd

add some data with a date (today) field

store in the same qvd

dseelam
Contributor

Re: How to store dynamically changing data

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

MVP
MVP

Re: How to store dynamically changing data

Z:

sql select * from oracletable;

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

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

Community Browser