Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AIShatiLove
Contributor III
Contributor III

How to clean up your data

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 🙂

Labels (4)
2 Solutions

Accepted Solutions
NitinK7
Specialist
Specialist

you can use where condition when loading the data like

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

and 

where Len(id)<>0

View solution in original post

MayilVahanan

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*');

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

8 Replies
NitinK7
Specialist
Specialist

you can use where condition when loading the data like

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

and 

where Len(id)<>0

AIShatiLove
Contributor III
Contributor III
Author

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
Specialist
Specialist

then you can use wildmatch function

MayilVahanan

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*');

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
AIShatiLove
Contributor III
Contributor III
Author

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.

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
AIShatiLove
Contributor III
Contributor III
Author

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

AIShatiLove
Contributor III
Contributor III
Author

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