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: 
bouderbc
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'

6 Replies
swuehl
MVP
MVP

Maybe

LOAD Title

FROM ....

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

surendraj
Specialist
Specialist

Load Title from sheet.xls

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

bouderbc
Creator
Creator
Author

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 ?

swuehl
MVP
MVP

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

bouderbc
Creator
Creator
Author

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

Thanx a lot

thedatabee
Contributor
Contributor

Hi Swuehl, can you please explain where should I put the where clause? 

I have given the col the name 'head'. 

LOAD head

FROM
[C:\Users\Kaunteya Shaw\Downloads\sheet.xls]


(biff, embedded labels, table is Sheet1$);

With best regards,

Kaunteya Shaw