Creating Own Employee in an Parent child Hierarchy structure

[SR]

Hi All,

I need some guidance in creating a row for the each manager in their parent child hierarchy. In the below table, employee Mark reports to DEF and indirectly reports to XYZ and finally to ABC. I want to create a 4th record for Mark reporting to himself . Basically what i want to achieve is for every employee i want to create a own record in their hierarchy structure.  Would Love some suggestions on how i can solve this issue.

ID	Name	Mgmt Level	Manager Name	Direct Manager
1234	Mark	01	ABC	No
1234	Mark	02	XYZ	No
1234	Mark	03	DEF	Yes
1234	Mark	04	Mark	No

[grazitti_sapna]

@SR , you can achieve this using self join. Please find the workflow to get your desired result.