Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Referencing Time

My question is how do I reference a time stamp?

Here is my problem:

I have a system in place where I can drop files into a directory. From there I ingest the files into qlik to make a report. How do I reference the time stamp when the file was dropped into the directory? For example, I dropped the file into the directory on the 3rd but I'm making the report on the 8th and I need to be able to reference that date and time of the 3rd.

Any help would be appreciated.

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Referencing Time

Try filetime() function:

Will return the timestamp of the last modification of the file xyz.xls.

Load *, filetime() as X from abc.txt ;

Will return the date and time of the last modification of the file (abc.txt) as a timestamp in field X in each record read

3 Replies
mov
Esteemed Contributor III

Re: Referencing Time

Try filetime() function:

Will return the timestamp of the last modification of the file xyz.xls.

Load *, filetime() as X from abc.txt ;

Will return the date and time of the last modification of the file (abc.txt) as a timestamp in field X in each record read

Not applicable

Re: Referencing Time

I am trying it right now. Thank you!

Not applicable

Re: Referencing Time

That worked. Thank you!