Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik Master,
I have a transaction table that contain 4 field of different type of employee id, and 1 employee master.
And what i want to do is to create a relationship between these two tables like picture below,
How to do this in QlikView?
Thanks,
Best Regards
Admin:
load distinct Admin_ID
From TransHeader;
Presales:
noconcatenate
load distinct Presales_ID
From TransHeader;
Sales:
noconcatenate
load distinct Sales_ID
From TransHeader;
QA:
noconcatenate
load distinct QA_ID
From TransHeader;
TransHeader:
load Trans_Id,
Admin_ID as Employee_ID
'Admin' as EmployeeType
From TransHeader
where exists(Admin_ID);
concatenate(TransHeader)
load Trans_Id,
Presales_ID as Employee_ID
'Presales' as EmployeeType
From TransHeader
where exists(Presales_ID);
concatenate(TransHeader)
load Trans_Id,
Sales_ID as Employee_ID
'Sales' as EmployeeType
From TransHeader
where exists(Sales_ID);
concatenate(TransHeader)
load Trans_Id,
QA_ID as Employee_ID
'QA' as EmployeeType
From TransHeader
where exists(QA_ID);
drop tables Admin,Presales,Sales,QA;
MS_Employee:
load *
From MS_Employee;