Where not + condition

[#1]

Hi,

I know how to use a "where not match" condition, but is it possible to use the same kind of statement with a condition to exclude data from a loaded table?

Like: Where not ... ([Salary]<50000);

Thank you

[Clever_Anjos · Accepted solution]

Yes, you just wrote it

where not [Salary]<50000

[tresesco]

May be like:

Load    

          Field1,

          Field2,

          Salary

Resident <tablename> Where Salary >=50000;  // equivalent to 'not Salary<50000'