QlikSense: Data cleaning functions in QLIKSENSE.

[@thinkmetrics]

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass
📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

[@pareshrahool3048]

Great content 😊

[@thinkmetrics]

Thanks

[@eliezergurevich1068]

thanks

[@thinkmetrics]

🙌🏻

[@ahmetkirisci920]

amazing

[@thinkmetrics]

🙌🏻🙌🏻🙌🏻

[@udayk7679]

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'

[@thinkmetrics]

Try Wildmatch(field, '*Jenkins*')

[@udayk7679]

Thanks a lot, Bro.