Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can anyone provide example of application(s) parsing local directories?

Hello,

Example applications automatically browsing directories and getting paths/file names are needed.  I heard that earlier there was an application called something like "Photos and Music" that I am not able to find. Any similar applications would be appreciated also.

Thanks in advance.

Arunas T.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Hi,

I think the "photos and Music" is part of the standard (server?) installation demo apps. Remember the app, forgot the location.

A similar application was maybe discussed here:

http://community.qlik.com/message/132617#132617

using

DataFilesList:

LOAD FileName()    as [File Name],

      FileTime()            as [Last Modified],

      FileSize()/1024    as [Size (kb)],

      Now()                  as [Reload Date]

FROM

[$(vExternalDataPath)\*.xls]

(biff, embedded labels, table is [Input Sheet$]) where RecNo() = 1;

to create a table with Excel-Filenames etc.

Regards,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Hi,

I think the "photos and Music" is part of the standard (server?) installation demo apps. Remember the app, forgot the location.

A similar application was maybe discussed here:

http://community.qlik.com/message/132617#132617

using

DataFilesList:

LOAD FileName()    as [File Name],

      FileTime()            as [Last Modified],

      FileSize()/1024    as [Size (kb)],

      Now()                  as [Reload Date]

FROM

[$(vExternalDataPath)\*.xls]

(biff, embedded labels, table is [Input Sheet$]) where RecNo() = 1;

to create a table with Excel-Filenames etc.

Regards,

Stefan

Not applicable
Author

Thank you! Photo and music was bundled with QV9 (I couldn't find it in version 10).