topic Re: update pb in QlikView

update pb

master_student — Sat, 29 Oct 2016 11:39:12 GMT

Hello community,

I have an update pb.

here is the script : to get data for a year in my qvd

test:

load *;

select * from xx

where date > '2016-01-01'

store test into case.qvd

AND then every day at 5 am whene the database is accessible I execute a reload task via QMC to run this script

test:

load *;

select * from xx

where date > today ()-1 // get day-1 data

concatenate

load * resident case.qvd;// get the data from my qvd

store test into case.qvd

my probleme is my data contains a status field that change. whene I do as I mentionned above (using qvd) I didn't get status updated . I can't run the script for a year evey time because the database is not accessible all the day.

What do you suggest please as a solution.

Thanks

Re: update pb

swuehl — Sat, 29 Oct 2016 15:00:47 GMT

Do your DB records hold a LastModified date field or something similar?

Something you can query to see which records changed?

Re: update pb

master_student — Sat, 29 Oct 2016 15:26:02 GMT

yes.

Re: update pb

swuehl — Sat, 29 Oct 2016 15:37:57 GMT

Then I suggest that you use this field in your WHERE clause for the incremental update.

Have a look at case 3 here:

Using QVD files for incremental load ‒ QlikView