Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Jonathan its working