topic Re: Read all file names from folder in QlikView https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117429#M629400 <HTML><HEAD></HEAD><BODY><P>Trythis?</P><P></P><P>LET vFolder = <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">'\\files</STRONG>\' ;</P><P></P><P>Sample:</P><P>LOAD FileBaseName() AS TestName</P><P>FROM $(vFolder)*.qvd(qvd);</P></BODY></HTML> Tue, 30 Aug 2016 19:53:08 GMT vishsaggi 2016-08-30T19:53:08Z Read all file names from folder https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117427#M629398 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i'm trying to load <STRONG style="text-decoration: underline;">only</STRONG> file names from the folder <STRONG style="text-decoration: underline;">but not</STRONG> the data in it.</P><P></P><P>When i try the below code, it is fetching data too..which is&nbsp; a performance issue.</P><P></P><P>Can someone please help?</P><P>Any help is highly appreciated!</P><P></P><P></P><P></P><P><STRONG>SET vFolder = '\\files'; //Storing the folder path in a variable.</STRONG></P><P></P><P><STRONG>Files:</STRONG></P><P><STRONG>LOAD </STRONG></P><P><STRONG>FileName() as Test</STRONG></P><P><STRONG> FROM $(vFolder)\*.qvd (qvd);</STRONG></P></BODY></HTML> Tue, 30 Aug 2016 19:14:53 GMT https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117427#M629398 markgraham123 2016-08-30T19:14:53Z Re: Read all file names from folder https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117428#M629399 <HTML><HEAD></HEAD><BODY><P>see the attachment:</P></BODY></HTML> Tue, 30 Aug 2016 19:48:09 GMT https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117428#M629399 m_woolf 2016-08-30T19:48:09Z Re: Read all file names from folder https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117429#M629400 <HTML><HEAD></HEAD><BODY><P>Trythis?</P><P></P><P>LET vFolder = <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">'\\files</STRONG>\' ;</P><P></P><P>Sample:</P><P>LOAD FileBaseName() AS TestName</P><P>FROM $(vFolder)*.qvd(qvd);</P></BODY></HTML> Tue, 30 Aug 2016 19:53:08 GMT https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117429#M629400 vishsaggi 2016-08-30T19:53:08Z Re: Read all file names from folder https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117430#M629401 <HTML><HEAD></HEAD><BODY><P>This loads all data in the files too Vish.</P></BODY></HTML> Tue, 30 Aug 2016 20:12:18 GMT https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117430#M629401 markgraham123 2016-08-30T20:12:18Z Re: Read all file names from folder https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117431#M629402 <HTML><HEAD></HEAD><BODY><P>This is awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks a lot!!</P></BODY></HTML> Tue, 30 Aug 2016 20:18:12 GMT https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117431#M629402 markgraham123 2016-08-30T20:18:12Z Re: Read all file names from folder https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117432#M629403 <HTML><HEAD></HEAD><BODY><P>Any idea how to do this in Qlik Sense?</P></BODY></HTML> Wed, 06 Sep 2017 15:57:13 GMT https://community.qlik.com/t5/QlikView/Read-all-file-names-from-folder/m-p/1117432#M629403 paulsparrow 2017-09-06T15:57:13Z