Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes, you just wrote it
where not [Salary]<50000
May be like:
Load
Field1,
Field2,
Salary
Resident <tablename> Where Salary >=50000; // equivalent to 'not Salary<50000'