Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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).