Need Help.!

[ychaitanya]

HI

I have a basic Employee table with Empid,Ename,Mgrid with following values

Empid,Ename,Mgrid
1,A,

2,B,1

3,C,2

4,D,2

Now i am displaying the List bos Empid ,Ename and Mgrid....So if user selects Empid .. we will get Ename and Mgrid values correspondingly.

But if i now want to show the manager name for that employee (which can drawn from the mgrid for that corresponding Empid which is again a empid).. Can you please help me in achieveing this??

[MK_QSL]

Searach Hierarchy from Reference manual and use the same here..

[Anonymous]

Hi!

To get this information I did the LOAD below:

LOAD Empid,

     Ename,

     Mgrid

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

LEFT JOIN

LOAD Empid as Mgrid,

     Ename as Mname

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

This way I've created a new field with the Name of the manager of the Employee.

Regards,

Gabriel

[ychaitanya]

I accept with the possibility of Hierarchial Load,Lookup and Excel Files..But is there any way that we could do in Dashboard using any functions?