topic Where Not WildMatch Not Working in QlikView

Where Not WildMatch Not Working

asmithids — Sat, 31 Oct 2015 19:07:44 GMT

Hello,

I have a load script below that I need to not include all names that start with 'ACCT' in the FirstName field. The where clause below is not working and is failing the load script (see attached screen shot).

The where clause looks right based on multiple posts on this topic in the Community. I'm not seeing where the issue is. Has anyone dealt with this issue?

Thank you in advance for any assistance.

Contacts:

LOAD LastName,

FirstName,

CompanyName,

Telephone1,

Telephone2,

Email,

AddressRecordNumber,

IsPrimaryContact;

SQL SELECT *

FROM METLABCORPORATION.Contacts

WHERE Not WildMatch(FirstName,'ACCT*');

Re: Where Not WildMatch Not Working

Sat, 31 Oct 2015 19:13:58 GMT

Hi Alec,

If you are using a SQL statement, you should use LIKE instead of WildMatch:

WHERE FirstName NOT LIKE 'ACCT%'

Best regards,

Daniel

Re: Where Not WildMatch Not Working

marcus_sommer — Sat, 31 Oct 2015 19:14:04 GMT

The where condition with wildmatch() which is a qv-functions needs to applied to the preceeding-load:

Contacts:

LOAD LastName,

FirstName,

CompanyName,

Telephone1,

Telephone2,

Email,

AddressRecordNumber,

IsPrimaryContact

WHERE Not WildMatch(FirstName,'ACCT*');

SQL SELECT *

FROM METLABCORPORATION.Contacts;

- Marcus

Re: Where Not WildMatch Not Working

swuehl — Sat, 31 Oct 2015 19:23:03 GMT

Marcus is right that you can only use Wildmatch in the LOAD statement.

It might be preferable to let the DBMS filter the records, so something like this should also work:

Contacts:

LOAD LastName,

FirstName,

CompanyName,

Telephone1,

Telephone2,

Email,

AddressRecordNumber,

IsPrimaryContact;

SQL SELECT *

FROM METLABCORPORATION.Contacts

WHERE FirstName NOT LIKE 'ACCT%';

Re: Where Not WildMatch Not Working

asmithids — Sat, 31 Oct 2015 19:58:31 GMT

Thank you Marcus. I won't make that mistake again

Re: Where Not WildMatch Not Working

asmithids — Sat, 31 Oct 2015 19:59:32 GMT

Thank you swuehl. That did the trick.

Re: Where Not WildMatch Not Working

asmithids — Mon, 02 Nov 2015 20:28:50 GMT

Thank you Daniel