topic Re: Re: Lookup in QlikView

Lookup

Thu, 27 Nov 2014 15:35:16 GMT

I have table A which is having column ID , Name,SupervisorID

ID Name SupervisorID

1 A 3

2 B

3 C 2

4 D 2

I want to show ID , Name, Supervisor Name , without using hierarchy load .

ali_hijazi — Thu, 27 Nov 2014 15:49:19 GMT

what do you mean by hierarchy load

Anonymous — Thu, 27 Nov 2014 16:05:05 GMT

How about something like this ?

Temp:

LOAD * INLINE [

ID, Name, SupervisorID

1, A, 3

2, B

3, C, 2

4, D, 2

];

SuperMap:

Mapping

load

ID as SupervisorID,

Name as SupervisorName

resident Temp

;

Data:

NoConcatenate

load

ID,

Name,

SupervisorID,

applymap('SuperMap',SupervisorID, null() ) as Supervisor

resident Temp

;

drop table Temp ;

nagaiank — Thu, 27 Nov 2014 16:19:48 GMT

You may use HIERARCHY load using ID as NodeID, SupervisorID as ParentID.

Qlikview 'Help' gives the details of Hierarchy prefix.