Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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*');