topic Self join in script in QlikView

Self join in script

Tue, 22 Sep 2015 13:34:40 GMT

Hi Folks,

How can we do self join in expression of straight table.

Data is

EmpName,ID_Emp,ID_Sup,Sales

ABC,1,2,21

XYZ,2,3,32

ZDC,3,4,4

LMN,4,5,33

I Need straight table with

SupID SupName EmpID

2 XYZ 1

3 ZDC 2

4 LMN 3

alexandros17 — Tue, 22 Sep 2015 13:38:55 GMT

You do not need any join, just reload with NoConcatenate the fields you need

alexandros17 — Tue, 22 Sep 2015 13:40:39 GMT

TableA:

Load EmpName,ID_Emp,ID_Sup,Sales Resident ...

TableB:Noconcatenate

Load

ID_Sup as SupID, EmpName as SupName, Id_Emp as EmpID resident TableA;

drop table TableA;

Tue, 22 Sep 2015 13:40:59 GMT

I can't reload, I will have to write something in expression of table.

alexandros17 — Tue, 22 Sep 2015 13:42:46 GMT

So write a table with the fields you need, if you need a chart then add an expression with 1 as value then hide the column

Tue, 22 Sep 2015 13:58:05 GMT

Could you please share a qvw with example, as I have already tried adding in table.

Tue, 22 Sep 2015 15:41:22 GMT

Any help would be really appreciated.

hic — Tue, 22 Sep 2015 19:30:17 GMT

This looks like a hierarchy to me, where ID_Emp is the NodeID and ID_Sup is the ParentID. If so, you should look at the Hierarchy prefix.

In any case, you cannot make a join in a straight table. You need to do it in the script.

HIC