Adding file name to qlikview

[#1]

I have a folder that has many log files each is 4KB, the only place that has a date it in the log file name. I would like to add this as a column inqlikview.

I am able to get all the files to load by using the following script.

Load @1 as Memo

From

[\\TCSPICEWORKS\ASALogs\CorpUSA\LOG*]

The log files are all named "LOG-2012-01-30-122123" I would like to include the "LOG-201201-30"

as a column in my QlikView File or the Date Modified from the log file

[swuehl · Accepted solution]

For the modification timestamp, just use

LOAD

..

filetime() as ModTimeStamp,

...

Or use filename() and extract the Date, maybe using subfield() function.

Hope this helps,

Stefan

edit:

if you don't want a timestamp but a date of your modification, use

daystart(filetime()) as ModDate,