Discussion Board for collaboration related to QlikView App Development.
I have two excel files with employee details.
Load the two excels and display only the employes who are working
You can create a field on resigned excel called Flag_Resigned and set all to 1
Set the employee name the same on both excel and load them with a join
Load EMPLOYEE_TEMP, OTHER_COLS_TEMP
from all.xls ...
Load EMPLOYEE_TEMP, FLAG_RESIGNED_TEMP
from resigned.xls ..
EMPLOYEE_TEMP as EMPLOYEE,
OTHER_COLS_TEMP as OTHER_COLS,
if( isNull(FLAG_RESIGNED_TEMP), 0, FLAG_RESIGNED_TEMP) as FLAG_RESIGNED
drop table TEMP_DATA;
The following script logic will work.
load ID from [All Employees];
Left Join Load ID, 1 as Flag from [Resigned Employees];
load ID resident AllEmployees where Flag <> 1;
left Join load * from [All Employees]; // to load all data of each employee
Drop Table AllEmployees;
I'd load the resigned employees first, and load all employees after that with condition
where not exists(<resigned employee id>, <all emplyee id>)
After that, drop the resigned table if it is not needed.