topic Re: Load from table from excel where date = max(date) in QlikView

Load from table from excel where date = max(date)

Anonymous — Fri, 19 Apr 2013 14:42:47 GMT

Hi All,

I have a set of excel data file genreated for every week ..i'm using a for loop to pull everything in Qlikview

now the issue is from the latest file i need to pull some additional data ..

so i'm giving some conditon like if (data = max(date) after load statement and in the where clause

how to write a condition for something like this

plz help ..if my question doesn't make sense please let me know so that i can comeup with a better way of presenting the same question

Thanks

Have a woderful weekend

Anonymous — Fri, 19 Apr 2013 15:35:27 GMT

FOR

EACH File in the fileist ('path'&* &'string')

WorkbooksTemp:

LOAD

right

(SubField('$(File)','.',1),4) as Year,
left(SubField('$(File)','Act_',2),3) as Month,
'$(File)' AS WorkbookName

Autogenerate 1;

This is the script for loading all the excel files in a folder

using year and month i can create a date field but

i want to use a where conditon to pull only one latest file where date is maximum

shree909 — Fri, 19 Apr 2013 15:46:15 GMT

First Load everything into the QVD ..

From that qvd take the max date with the resident load and store that as an qvd...