Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

evgeniystuchalk
Contributor II

Using "where" on load from DB: problem with 'wildmatch' function

Hello! Here is my code in the end of load sript:


FROM `amo_akz`.leads where `status_name`<>'Новый заказ' and `status_name`<>'Ожидает подтверждения (Call center)' and `status_name`<>'' and wildmatch(`responsible_user_name`,'*Мен*')='1';

On compilation i'm getting error:

SQL##f - SqlState: 37000, ErrorCode: 1305, ErrorMsg: [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.38-0+wheezy1]FUNCTION amo_akz.wildmatch does not exist


Without "wildmatch" everething is ok. What to do to make it work?

1 Solution

Accepted Solutions
MVP
MVP

Re: Using "where" on load from DB: problem with 'wildmatch' function

Wildmatch() is a qv qlik function that doesn't get recognized by SQL engine. Rather try with Like, like:

...`status_name`<>'' and `responsible_user_name` like '%Мен%';

1 Reply
MVP
MVP

Re: Using "where" on load from DB: problem with 'wildmatch' function

Wildmatch() is a qv qlik function that doesn't get recognized by SQL engine. Rather try with Like, like:

...`status_name`<>'' and `responsible_user_name` like '%Мен%';

Community Browser