contains field not working properly

[saivina2920]

Hi,

I am trying to apply contains value in my if statement.

if i use [FROM] = '*MANNING*' ==> not working

if i use [FROM] LIKE  '*MANNING*' ==> working (But, not sure whether it is filtered correct or not

[MayilVahanan · Accepted solution]

HI @saivina2920 

Try with wildmatch like

Wildmatch(From, '*manning*')

[Vegar]

Is it used in a LOAD statement or in a SQL SELECT statement?

If it is a SQL SELECT statement then you should use SQL syntax for that database type. LIKE could be a valid statement, but wildmatch() is not.

If it is within a LOAD statement then you cannot use LIKE, it is not a part of the Qlik syntax. You can use wildmatch() instead as @MayilVahanan suggested.

[saivina2920]

Thanks...we are using LOAD statement..