How to clean up your data

[AIShatiLove]

HI, Qlik !
i wonder, how can i manage all my data in qlik, i want to filter and delete values that i don't want to have in my final dataset , for examp, i want to delete all rows that in column "Name" start with "g"(better if it will be case insensetive)  or  in the "id -number" delete all rows where the id-value is empty . I'm interested in all the ways I can do this.  Thanks You for answers 🙂

[NitinK7 · Accepted solution]

you can use where condition when loading the data like

where Capitalize(Left(Name),1)<>'G'

and 

where Len(id)<>0

[AIShatiLove]

cool, but what if i would have several conditions, for example, not just one "G", but also "B" and "C" ? 
 or whai if i need to delete only values that contain  part of the word, how can i find them ?

[NitinK7]

then you can use wildmatch function

[MayilVahanan · Accepted solution]

HI @AIShatiLove 

Try like below

not Wildmatch(Name,'G','B', 'C') ;

I need to delete only values that contain  part of the word?? <-- try like below

not wildmatch(Name, '*ga*');

[AIShatiLove]

thanks for the detailed solution, but I don't fully understand how wildmatch  works, the documentation says that it returns the number of matches

[MayilVahanan]

Hi @AIShatiLove 

By using Wildmatch, we can compare the case insensitive values & also part of the word. 

If the passing value matches with field values , then it will return 1, else return 0.

[AIShatiLove]

should i use smth in combination with wildmatch to get  filtered values ?

[AIShatiLove]

should i use smth in combination with wildmatch to get  filtered values ? 
cause i read in documentation that wildmatch returns the number of matches,  not particular values