Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

table show file name of a directory

Hi everybody,

I would like to show in a table a list of filenames taken from the same directory.

The filename has the same structure: 20xxmmdd_hhmmss_t1.csv

which is the data in year,month,day and the time in hours,minutes,seconds.

if is possible I would like to show the date of the file name in the table and select the relative data of the file from this table.

can you help me?

thank you!

Giacomo

1 Reply
bnichol
Not applicable

table show file name of a directory

Try using the following functions within your load statement...

filepath(), filename() and filentime()

QlikView help has more on these functions.

Good luck,

B