topic Re: Load Text Files Dynamically with Timestamp in QlikView

Load Text Files Dynamically with Timestamp

zwyne — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Load Text Files Dynamically with Timestamp

jonathandienst — Thu, 22 Mar 2018 13:24:59 GMT

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

Re: Load Text Files Dynamically with Timestamp

zwyne — Thu, 22 Mar 2018 13:32:57 GMT

Thanks Jonathan its working