Prob

[nikhilgarg]

Hey,

I have a situtation of heirarchy, where i have to show all reporting managers.

I have attached snasphot.

I want Employee2, Employee3, EMployee4, Employee5 under same column as EmployeeName.

And Manager column is underlying expression.

[miguelbraga]

Hi there,

Here take a look at these documents. It will help you understand better the hierarchy issue

Regards,

MB

[miguelbraga]

Hey again,

If my document didn't help you, can you please share your .qvd document?

Thanks,

MB

[settu_periasamy]

Hi Nikhil,

May be try to use Concatenate all the Employee Fields.

Like

A:
LOAD * INLINE [
     Emp, Emp1, Emp2, Emp3
    1, 2, 3, 4
    3, 4, 5, 6
];

New:
Load Emp Resident A;
Concatenate
LOAD Emp1 as Emp Resident A;
Concatenate
LOAD Emp2 as Emp Resident A;
Concatenate
LOAD Emp3 as Emp Resident A;


DROP Table A;