Script Help for handling Vacant Managers in Hierarchy

[aveeeeeee7en]

Dear Community

Please see the Attachment and help me in writing the correct Script for for handling Vacant Managers in Hierarchy.

Regards

Aviral

[hic]

You cannot use 'Vacant' as ID for an employee. You need to create a unique ID for each position, e.g.

     'Vacant' &'_'& DivisionalHead &'_'& MANAGER_POSN as ID

Further, you need to use this ID both as [EmpID] and [Reporting To].

HIC

[aveeeeeee7en]

Thank You Henric Sir for your response

I have a requirement to fill Nulls with 'Vacant' in Hierarchy at the same position where the person was earlier. Every person has its Manager Position.

I have worked on the Logic but got stuck at one point, to adjust person at similar place where it was earlier.

Kindly see the Attachment.

Regards

Aviral Nag

[aveeeeeee7en]

Any Suggestions.

[hic · Accepted solution]

You are mixing Employee ID with Employee Name, and that's why it doesn't work:

A solution can be found in the attachment.

HIC

[aveeeeeee7en]

Thank You Henric Sir

It works. Perfect Solution. That's New Learning to me. Never seen something like this before. Incredible Stuff.

Regards

Aviral Nag