Bro, please help 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 "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'