topic Re: Ignore Certain Excel Files from path in QlikView

Ignore Certain Excel Files from path

kiranpatil123 — Sat, 16 Nov 2024 19:52:52 GMT

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

Re: Ignore Certain Excel Files from path

martinpohl — Thu, 17 Oct 2019 11:51:57 GMT

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

Re: Ignore Certain Excel Files from path

Frank_Hartmann — Thu, 17 Oct 2019 12:18:27 GMT

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