Data load editor where clause

[Qlikuser09]

I want to create a new table from the existing table using the load function.I am trying to load the data that has the word "%senior% " in the data.  however, the load condition is fetching all the data irrespective of the where condition and want to create a flag based on that condition

Test:

load

Field 1, field 2 

resident table 1

where field 1 = "%Senior"

[MayilVahanan]

HI

Try like below

load

Field 1, field 2 

resident table 1

where wildmatch(field 1 ,'%Senior*');

It will fetch all the field1 records contains word '%Senior' .