resident where not like

[Anonymous]

Hi all,

I have the problem with the following:

Load

a1,

b1

resident table1

where field 1 like 'de*' and not field2 like 'e*'

The problem is that "not field2 like ..." doesn't work.

Any ideas?

Thank you for helping!

[arsal_90]

put not(field2) i hope it works

[rwunderlich]

Could you be more specific about "not working"? Do you get a script error or don't get the filtering you expect?

-Rob

[MK_QSL · Accepted solution]

Try like below

======================================

Load

a1,

b1,

.....

resident table1

where field1 like 'de*' and not WildMatch(field2,  'e*');

============================================

Something like

Load  * Resident TableName

Where Customer Like 'A*' and

Not WildMatch(Country, 'P*');

============================================

[Anonymous]

Hi Rob,

the problem is that I don't get the filtering I expect.

[swuehl]

Robert,

without detailing what you expect to see (for example giving input data and your expected output table), it's almost impossible to help you.

[Anonymous]

THX:, I had to put [field test] with []