Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Ignore Certain Excel Files from path

Hi All ,

I'm Loading all excel files from particular Path by giving * (around 50 excel files) .

I want to restrict (dont want to read them) some excel files Starting with '3rd Party' .

How do i do that ?

Advance Thanks

Labels (1)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Or maybe like this:

for each file in filelist('C:\Users\admin\Desktop\Neuer Ordner\*.xlsx')
   if WildMatch(text('$(file)'), '*3rd Party*') = 0 then
      load * 
      from [$(file)] (ooxml, embedded labels, table is Tabelle1)  ;
   end if   
next

View solution in original post

2 Replies
martinpohl
Partner
Partner

for each vFile in filelist('yourpath\*.xls')

if substring('$(vFile)',\',-1) like '*3rd Party' then

Trace 3rd Party, not loaded;

else

load

*

from $(vFile);

endif

next

Frank_Hartmann
Master II
Master II

Or maybe like this:

for each file in filelist('C:\Users\admin\Desktop\Neuer Ordner\*.xlsx')
   if WildMatch(text('$(file)'), '*3rd Party*') = 0 then
      load * 
      from [$(file)] (ooxml, embedded labels, table is Tabelle1)  ;
   end if   
next

View solution in original post