Script Load - Latest records and date

owhittle — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have been struggling for quite a while and scanned the forums to come up with a method how to load the latest information from my qvd files which are created everything morning around 5 am from a database pull. This original qvd file I would not like to ammend as it is used by many applications.

I have another application where I would like to load the latest records e.g. max(date(Transact_time, 'DD/MM/YYYY')) or from the previous day. max(date(Transact_time, 'DD/MM/YYYY')-1). (my dates are all dates + times stamps)

TEMP:

LOAD

max(Date) AS MAX_Date

FROM

[file1.qvd]

let vTemp=MAX_Date

drop table TEMP;

Table1:

LOAD

Field 1

Field 2

Date

FROM

[file1.qvd]

WHERE Date >= $(vTEMP);

The above is an example of a method I have tried with no success as well as trying to Join/resident tables. The outcome I would like is if i have 1 years worth of data in a QVD, I am only targeting 1 day, however could have 1000 different timestamps which are all included in the load.

Hope this is clear.

Re: Script Load - Latest records and date

ElizaF — Thu, 08 Feb 2018 18:52:11 GMT

Corect expresion for vTemp variable is:

let vTemp=Peek('MAX_Date',0,'TEMP');

topic Re: Script Load - Latest records and date in QlikView

Script Load - Latest records and date

Re: Script Load - Latest records and date