Macro

BRRLL99

Hi Team,

I have following data , for Each Employee Hierarchy of Managers need to be build , I have build this using multiple joints, I'm looking for Macro Solution

Input:  

ID	NAME	LEVEL	MANAGER ID	Manger NAME
101	SAM	6	108	TAYLOR
102	JOE	6	108	TAYLOR
108	TAYLOR	4	121	KRISTINE
110	RAH	4	121	KRISTINE
121	KRISTINE	3	111	GADE
111	GADE	MD
199	ROCKY	7	177	BLAKE
177	BLAKE	6	188	JUSTIN
188	JUSTIN	5	108	JASON
108	JASON	4	123	TIM
123	TIM	3	143	JIM
143	JIM	2	111	GADE

Expected Output : I have attached the solution , Looking for Macro Solution
Note : there is no rule that Employee will be reporting to next level Manager he can directly report to MD as well

ID	NAME	LEVEL	MANAGER ID	Manger NAME	Manager_LEVEL
177	BLAKE	6	188	JUSTIN	5
177	BLAKE	6	108	JASON	4
177	BLAKE	6	123	TIM	3
177	BLAKE	6	143	JIM	2
177	BLAKE	6	111	GADE	MD
108	JASON	4	123	TIM	3
108	JASON	4	143	JIM	2
108	JASON	4	111	GADE	MD
143	JIM	2	111	GADE	MD
102	JOE	6	108	TAYLOR	4
102	JOE	6	121	KRISTINE	3
102	JOE	6	111	GADE	MD
188	JUSTIN	5	108	JASON	4
188	JUSTIN	5	123	TIM	3
188	JUSTIN	5	143	JIM	2
188	JUSTIN	5	111	GADE	MD
121	KRISTINE	3	111	GADE	MD
110	RAH	4	121	KRISTINE	3
110	RAH	4	111	GADE	MD
199	ROCKY	7	177	BLAKE	6
199	ROCKY	7	188	JUSTIN	5
199	ROCKY	7	108	JASON	4
199	ROCKY	7	123	TIM	3
199	ROCKY	7	143	JIM	2
199	ROCKY	7	111	GADE	MD
101	SAM	6	108	TAYLOR	4
101	SAM	6	121	KRISTINE	3
101	SAM	6	111	GADE	MD
108	TAYLOR	4	121	KRISTINE	3
108	TAYLOR	4	111	GADE	MD

Sample_Hierarchy.yxmd

Qiu

@BRRLL99 
I would recommend to use this hierarchy generation macro, and I have made some further processing to the hierarchy you required.

Noted that it appears that there is duplicated Names for ID 108 so have modified the ID of JASON to 109.

1108-BRRLL99.yxzp