topic Re: Exclude string of values from load? in QlikView

Exclude string of values from load?

Wed, 24 Apr 2013 14:57:13 GMT

Hi,

I'm trying to exclude any client where the name is "Trendsight" from my load, but my statement doesn't seem to be working...

LOAD

ClientName,

FROM

Data\Clients.qvd

(qvd) where ClientAccountName<>WildMatch(ClientAccountName, 'Trendsight.*');

Any thoughts? The issue is that this client has multiple divisions that we treat as separate clients, so I need a string variable rather than manually excluding each client from the load.

Re: Exclude string of values from load?

hic — Wed, 24 Apr 2013 15:17:02 GMT

LOAD ClientName,

FROM Data\Clients.qvd (qvd) where not WildMatch(ClientAccountName, 'Trendsight*');

HIC

Re: Exclude string of values from load?

Wed, 24 Apr 2013 15:20:15 GMT

LOAD

ClientName

FROM Data\Clients.qvd (qvd)

where NOT (ClientAccountName like 'Trendsight*')

;

Re: Exclude string of values from load?

Wed, 24 Apr 2013 15:26:29 GMT

Ahhh, that's it. Worked perfectly, thank you!