Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Load Text Files Dynamically with Timestamp

Hello All,

I have multiple text files in the folder with different timestamp, so what I want to do is create a one qvd with a new column for date and timestamp based on the filename.

So the expected output will one qvd like:

ecrime and the associated dates and time columns

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Load Text Files Dynamically with Timestamp

You should be able to do it like this:

Date(Date#(SubField(FileBaseName(), '_', 3), 'yy.MM.dd'), 'yyyy-MM-dd') as Date

Time(Round(Time#(SubField(FileBaseName(), '_', 4), 'hh.mm.ss'), 1/1440), 'hh.mm') as Date

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Load Text Files Dynamically with Timestamp

You should be able to do it like this:

Date(Date#(SubField(FileBaseName(), '_', 3), 'yy.MM.dd'), 'yyyy-MM-dd') as Date

Time(Round(Time#(SubField(FileBaseName(), '_', 4), 'hh.mm.ss'), 1/1440), 'hh.mm') as Date

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Highlighted
Creator
Creator

Re: Load Text Files Dynamically with Timestamp

Thanks Jonathan its working