Try this script one by one, before that ensure connection string is working properly -
//Load Employee table
Source:
Load Timestamp#(TIMEOUT,'DD-MM-YY hh:mm') as TIMEOUT,
Timestamp#(TIMING,'DD-MM-YY hh:mm') as TIMING,
BRANCH_ACC_ID;
SQL Select
TIME_OUT,
TIMING,
BRANCH_ACC_ID
From
EMPLOYEE;
//Inner join ATTENDANCE_DETAIL with Employee table( Employee table is loaded into Qlik table 'Source')
// Check the field names required to be loaded, if more than one fields have same name, records will be loaded
//only if all fields are matching in both the tables as we are using Inner join here.
Inner Join(Source)
Load Timestamp#(TIMEOUT,'DD-MM-YY hh:mm') as TIMEOUT,
Timestamp#(TIMING,'DD-MM-YY hh:mm') as TIMING,
BRANCH_ACC_ID;
SQL Select
TIME_OUT,
TIMING,
BRANCH_ACC_ID
From
ATTENDANCE_DETAIL;
//Calculating difference hours. 'Final' will be the output table having desired result. Check if * needs
//to be replaced with specific fields to avoid unused fields.
Final:
Load *,
Interval(TIMEOUT-TIMING,'D hh:mm') as DIFF_HOURS
Resident Source;
Drop table Source;
