Load Text Files Dynamically with Timestamp

[zwyne]

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

[jonathandienst · Accepted solution]

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

[zwyne]

Thanks Jonathan its working