topic Re: List of files in folder in App Development

List of files in folder

AndyS2 — Fri, 09 Aug 2024 16:53:30 GMT

How to list all files at a given file location (data connection)?

What I am looking for is the the same function as used to be possible using FileList() function but for a given data connection

Re: List of files in folder

marksouzacosta — Fri, 09 Aug 2024 17:05:10 GMT

Hi @AndyS2,

What is your Qlik Platform (QlikView, Qlik Sense, Qlik Cloud) and what is your Data Connection or Data Source (Folder connection, S3, Sharepoint, etc)?

Re: List of files in folder

AndyS2 — Mon, 12 Aug 2024 07:24:44 GMT

Hi Mark,

I'm using Qlik Sense and the Data Connection is a folder connection. For development purposes, it is a folder on my laptop...

...\Documents\Qlik\Sense\QDF\DEV\99.Shared_Folders\1.QVD\3.Load\revenue\dims

Re: List of files in folder

Kushal_Chawda — Mon, 12 Aug 2024 09:57:07 GMT

@AndyS2 see the below

https://community.qlik.com/t5/QlikView-App-Dev/List-of-files-in-a-folder/td-p/648029

Re: List of files in folder

marksouzacosta — Mon, 12 Aug 2024 13:53:56 GMT

You can use FileList and pass your Data Connection name like you would do with a regular Windows Path:
For example:

For Each vFile in FileList('lib:\\MyLib\MyFolder\*.qvd')

Next vFile

Re: List of files in folder

AndyS2 — Thu, 22 Aug 2024 10:42:32 GMT

Thanks for your help Mark