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

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

bouderbc — Thu, 28 Sep 2017 09:49:01 GMT

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'

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

swuehl — Thu, 28 Sep 2017 09:54:33 GMT

Maybe

LOAD Title

FROM ....

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

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

surendraj — Thu, 28 Sep 2017 09:58:08 GMT

Load Title from sheet.xls

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

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

bouderbc — Thu, 28 Sep 2017 10:58:03 GMT

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 ?

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

swuehl — Thu, 28 Sep 2017 11:01:12 GMT

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

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

bouderbc — Thu, 28 Sep 2017 11:14:39 GMT

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

Thanx a lot

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

thedatabee — Fri, 19 Mar 2021 05:20:35 GMT

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$);