Exclude Files from load

[bramvdpoel]

 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?

[DavidM · Accepted solution]

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*');