Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bramvdpoel
Contributor III
Contributor III

Exclude Files from load

 Hi there,

I want to load a list of files all starting with 200.* .

Only i need to exclude 200.0047 , 200.4761 & 200.4965.

What's the best way to proceed on this?

1 Solution

Accepted Solutions
DavidM
Partner - Creator II
Partner - Creator II

Like this:

LOAD
*
FROM [PATH/*.csv]
(txt, codepage is 28599, embedded labels, delimiter is ',', msq) //change to whatever type of file you're loading
WHERE NOT WildMatch(FileBaseName(),'200.0047*','200.4761*','200.4965*');

 

View solution in original post

1 Reply
DavidM
Partner - Creator II
Partner - Creator II

Like this:

LOAD
*
FROM [PATH/*.csv]
(txt, codepage is 28599, embedded labels, delimiter is ',', msq) //change to whatever type of file you're loading
WHERE NOT WildMatch(FileBaseName(),'200.0047*','200.4761*','200.4965*');