topic Re: pick the latest file ? in QlikView

pick the latest file ?

Tue, 28 Dec 2010 16:44:16 GMT

Hi togehter,

i want to load the latest csv file in my script and dont know how i realize it. How can i pick up the latest file from this Folder ?

In this case it would be the file "28779_2010-12-27.csv"

28779_2010-12-24.csv
28779_2010-12-25.csv
28779_2010-12-26.csv
28779_2010-12-27.csv

Thank you very much !

pick the latest file ?

Tue, 28 Dec 2010 16:50:59 GMT

First i would create a table with all files sorted byt their date:

first(1)

LOAD

ffilepath() as FileName,

filetime() as [Date File]

from

xxx\*.csv

order by filetime() DESC;

Then you take the name of the file

LET FileName = peek( 'FileName',0);

xxxx:

LOAD * FROM '$(FileName)';

Rgds,

Sébastien

pick the latest file ?

Tue, 28 Dec 2010 17:26:19 GMT

Hi Sebastien,

thank you but the editor does not accept this part ... ORDER BY FileTime() DESC;

FileTime() is red marked ! Did something missed ?

Thank you !

pick the latest file ?

Tue, 28 Dec 2010 17:35:58 GMT

here the code

FILESELEKTOR:
LOAD

FilePath() AS FileName,
FileName() AS DateFile

FROM H:\Qlikview Workspace\APILoader\reports\28779*.csv (utf8, txt, delimiter is ';', no labels, msq, header is 1 lines ) ORDER BY FileTime([FileName]) DESC;

LET FileName = peek('FileName',0);

Is that korrekt ? Thank you very much !

pick the latest file ?

Tue, 28 Dec 2010 19:04:13 GMT

nobody an idea ?

pick the latest file ?

Tue, 13 Mar 2012 06:39:45 GMT

Directory;

TEMP:

LOAD *,

filetime() as file_time,

filepath() as file_path,

filebasename() as z_file,

timestamp(filetime()) as time_stamp

FROM [Data\*.xls] (biff, embedded labels, table is Sheet1$);

left join (TEMP)

load

max(timestamp(file_time)) as max_time

resident TEMP;

FINAL:

LOAD *, 1 as flag

resident TEMP where time_stamp=max_time;

drop table TEMP;

Re: pick the latest file ?

Tue, 13 Mar 2012 06:44:16 GMT