topic Re: Self Join Load Error ? in QlikView

Self Join Load Error ?

Wed, 25 Nov 2020 16:16:04 GMT

QUALIFY*;

Emp:LOAD ID,

Employee,

[Designation ID],

Superior Id

FROM

(biff, embedded labels, table is Employee$);

Mgr:

LOAD Emp.ID As Mgr_ID,

Emp.Employee As [MgrName]

Resident Emp;

//UNQUALIFY*;

Temp:

Load Emp.EMPLOYEE_ID as Emp_Id, Emp.FIRST_NAME as Emp_name,Mgr.Emp.EMPLOYEE_ID as Mgr_Id,Mgr.Emp.FIRST_NAME as Mgr_Name

Resident Emp

Where Emp.MANAGER_ID = Mgr.Emp.EMPLOYEE_ID

Order by Emp.EMPLOYEE_ID;

DROP Table Emp;

The SQL Query for the Following is

Select e.Emp_ID,e.Employee, Mgr.Emp_ID, Mgr.Employee

from Emp e, Emp mgr

Where e.Emp_ID = Mgr.Emp_ID;

I have A table Employee, I Created another table using Resident Load I need to get Manager name using that I m unable to Execute Above script? Suggest Any Correction for the Script?

Re: Self Join Load Error ?

Anil_Babu_Samineni — Sat, 17 Dec 2016 16:45:16 GMT

You want to implement that sql into Qlikview, you mean to say this

Qualify *;

Load Emp_ID, Employee from <Data Source>

Qualify *;

Mgr:

Load Emp_ID,Employee from <Data Source>

Final:

Left Join(e)

Load * Resident e

Left Join(Mgr)

Load * Resident Mgr Where e.Emp_ID = Mgr.Emp_ID;

Drop Table Tables e, Mgr;

Re: Self Join Load Error ?

Sun, 18 Dec 2016 14:35:59 GMT

Thank You for taking time.

I worked out as per your script I m getting the Error Please Suggest.

Re: Self Join Load Error ?

Anil_Babu_Samineni — Mon, 19 Dec 2016 05:40:00 GMT

Can you send real data with the scramble data. So, Please send your application to work