How to load active employees only?

[wgonzalez]

I want to load active employees only to the table in the script.  Active employees are coded in the Status column, how can I filte to load those with a specific code only?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

You can do that either in the SQL statement or in the LOAD statement. The SQL is likely to be faster, except when using QVD files:

ActiveEmployees:
LOAD *
WHERE Status = 'A'; // the Status field is spelled and capitalized as it is recorded in the database, upper or lowercase
SQL SELECT *
FROM database.EmployeeTable;

Hope that helps.

Miguel

[wgonzalez]

Thanks!