Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
FOR
EACH File in the fileist ('path'&* &'string')
WorkbooksTemp:
LOAD
right
(SubField('$(File)','.',1),4) as Year,Autogenerate 1;
next
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
Hi
First Load everything into the QVD ..
From that qvd take the max date with the resident load and store that as an qvd...