Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Text filter data in the load script ? (where text contains...) Help!!!!

Text filter data  in the load script  ? (where text contains...)

usually  i use where but in my case it doesn't work properly because i have different types of character string ( Alpha numeric character, text character ) and they aren't always the same , please see the example below and File Attached :

When i want to filter on security with where , he did the job but he loads also other parts of the file , so is not efficient

please if u know this case , give me your solutions !

Name of the column: Title

Needs: Filter only where the field contains 'security'

5 Replies
Highlighted
MVP
MVP

Maybe

LOAD Title

FROM ....

WHERE Wildmatch(Title,'*Security*');

Highlighted
Specialist
Specialist

Load Title from sheet.xls

where wildmatch(title,'* security*');

Highlighted
Creator
Creator

Hi Stephan,

Thanx for your answer , i have already use it , it doesn't work properly , so i use a flag as a filter  :

if(WildMatch(Title,'*Security*'),'True','False') as Flag ,

i can filter now on my Data ,  but Now i want to use this flag in the load script, is it possible ?

Highlighted
MVP
MVP

Can you upload a sample QVW with some sample data that demonstrates where the WHERE clause does not work properly?

Highlighted
Creator
Creator

Stephan , sorry  i can't share my Data , but i put an excel sample.

Thanx a lot