Hi! I am trying to create an organization chart so that each employee is assigned a variable showing the count of people lower than themselves in the hierarchy. For each employee, I have their immediate boss. This is representative input data: EmployeeID of employeeEmployeeID of boss1110034411511611 The output should show the number of people under each person, like this: EmployeeID of employeecount114304150601005 I feel like I need to loop through the data but not sure where to start. Can you help?

Iterate through employee files to generate org chart

Hi!

I am trying to create an organization chart so that each employee is assigned a variable showing the count of people lower than themselves in the hierarchy. For each employee, I have their immediate boss.

This is representative input data:

EmployeeID of employee	EmployeeID of boss
11	100
3	4
4	11
5	11
6	11

The output should show the number of people under each person, like this:

EmployeeID of employee	count
11	4
3	0
4	1
5	0
6	0
100	5

I feel like I need to loop through the data but not sure where to start. Can you help?

Help

Accepted answers

john_miller9

@abDC49

See the attached workflow which gets your employee counts by manager tree. Let me know if you have any questions.

Shout out to @jdunkerley and all of his contributions around hierarchies. I've been leveraging and building upon his previous work in many iterative macros I've created.

Hierarchy Child Count.png

Hierarchy Child Count.yxzp

All comments

john_miller9

Hi @abDC49 ,

This is similar to one of the weekly challenges here.

Have you taken a look at that example?

EDIT: Now that I'm thinking of it, this is a bit different from the exercise, but similar to an HR Hierarchy macro I created a few years ago. Let me dig that up

smoskowitz

iterative macro will get the job done. There are videos on this type of macro. Have you had a chance to watch one? Let me know if you need further help.

Seth

john_miller9

@abDC49

See the attached workflow which gets your employee counts by manager tree. Let me know if you have any questions.

Shout out to @jdunkerley and all of his contributions around hierarchies. I've been leveraging and building upon his previous work in many iterative macros I've created.

Hierarchy Child Count.png

Hierarchy Child Count.yxzp

abDC49

@john_miller9 - This is exactly what I was looking for. Thank you so much!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703