Use Direct discovery to find max date

[thierrytt1102]

Hi,

I have a large qvd file and I'd like to use incremental load to refresh it.

I need the max date of this qvd file without loading it in the script.

Would it be possible to use direct discovery to find the max date of the qvd or does it work only with like a sql query?

thxs

[agomes1971]

Hi,

yes on your own words...

or does it work only with like a sql query?

Regards

André Gomes

[Anonymous]

Hi,

Why cant you try getting the max date into a variable and save it as separate QVD which will have only Max Date,   before storing the huge QVD or before dropping the Table after storing it into QVD

Regards

Harsha

[Anonymous]

Hi ,

You dont need to load whole QVD you can just load max (updatedate) from qvd. and use that date into your load

LOAD max(Period) as MaxModified FROM Test.qvd (qvd);

[thierrytt1102]

Thx this solution was my alternative 😉

[thierrytt1102]

This was my actual solution but QV still has to load all the values of that field.

thx

[Anonymous]

Good That might be better as you said QVD is huge

[mikkeltaylor · Accepted solution]

I was about to try this today for the same issue

QlikView: Using FieldValue() to get Minimum and Maximum Dates from a Large QVD file | Hyunku's Blog