Qlik Community

Community Corner

Discussion board for questions about the Qlik Community Platform as well as general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
Submit your remarkable customer story for the Global Transformation Awards at QlikWorld Denver 2022. SUBMIT A STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding file name to qlikview

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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,

View solution in original post

1 Reply
swuehl
MVP
MVP

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,

View solution in original post