Multi Field to Single Field Relationship ?

rendiyan — Tue, 01 Dec 2015 07:40:06 GMT

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

Re: Multi Field to Single Field Relationship ?

Kushal_Chawda — Tue, 01 Dec 2015 09:31:34 GMT

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;

topic Re: Multi Field to Single Field Relationship ? in QlikView

Multi Field to Single Field Relationship ?

Re: Multi Field to Single Field Relationship ?