Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

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

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

2 Replies
MVP
MVP

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

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

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

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

Community Browser