topic How to load active employees only? in QlikView

How to load active employees only?

wgonzalez — Thu, 03 May 2012 15:38:11 GMT

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?

Re: How to load active employees only?

Miguel_Angel_Baeyens — Thu, 03 May 2012 15:42:35 GMT

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

How to load active employees only?

wgonzalez — Thu, 10 May 2012 14:13:36 GMT

Thanks!