if condition using wild cards

[Udayk76]

Please any can any one help me with the below scenario,

I have a scenario, where if a record in a column contains a word "jenkins" then i want to create a new column and mark the particular record as a "bug", if not keep the record as it is.

I tried the below if condition but unfortunately qlik doesn't support wildcards

tried this in table: if(field1 = '*jenkins*', 'bug', field1)

tried this in script: if(field1 = '*jenkins*', 'bug', field1) as 'field2'

Thanks in advance

[kaushiknsolanki]

Hi you should try below.

if(wildmatch(field1,'*jenkins*'), 'bug', field1)

[henrikalmen]

Use wildmatch(), it supports wildcards. So something like if(wildmatch(field1, '*jenkins*'), 'bug', field1)

[MarcoWedel]

you could also try the 'like'-operator instead of the '=' sign, i.e.:

if(field1 like '*jenkins*', 'bug', field1)

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Operators/....

[Udayk76 · Accepted solution]

Thank you @MarcoWedel  @henrikalmen  @kaushiknsolanki  for your help. I'm really thrilled for your prompt response. The above like and wildmatch functions worked like a magic. They satisfied the requirement. Thanks again. All the best. 👍

[Udayk76]

Just wanted to know, is there a way to check whether wildmatch function is efficient or the like function is efficient. As both functions are satisfying the requirement. 

Thanks in advance