Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi there,
Here take a look at these documents. It will help you understand better the hierarchy issue
Regards,
MB
Hey again,
If my document didn't help you, can you please share your .qvd document?
Thanks,
MB
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;