Forum Discussion
Solved
Org chart without 'parent id', only a field 'manager'
A have org data in excel. A "Manager' column is used to state the hierachy between the employee and his/her manager. There are no parent id or child id fields available. How can i create an org chart...
Adescrit I followed steps 1,2 & 3, and then created Index_Parent = LOOKUPVALUE(Table[Index_child], Table[Employee_name], Table[Manager_name] )
After this used a visulaization from market place to create the visuals. This worked !!
Adescrit Index that we created in step3 should be unique right ? Because in the step 7 we create again index for managers, where as managers also also there in step 3 where they already have an index and hence these index will be different. So when we merge it will not create the proper parent child relation rather some cyclic relationships.