1 Reply Latest reply: Feb 2, 2012 1:52 PM by Stefan Wühl RSS

    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

       

       

       

       

       

       

        • Re: Adding file name to qlikview
          Stefan Wühl

          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,