Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thank you! Photo and music was bundled with QV9 (I couldn't find it in version 10).