Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
you can use where condition when loading the data like
where Capitalize(Left(Name),1)<>'G'
and
where Len(id)<>0
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*');
you can use where condition when loading the data like
where Capitalize(Left(Name),1)<>'G'
and
where Len(id)<>0
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 ?
then you can use wildmatch function
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 for the detailed solution, but I don't fully understand how wildmatch works, the documentation says that it returns the number of matches
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.
should i use smth in combination with wildmatch to get filtered values ?
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