Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dataset like below . We have name , manager and manager job title. we need to find director and vicepresident for each of these names
For example , for user Alex , he is reporting to Victor. but victor is Sr. Manager in position. Victor is reporting to Susan who is Vice President. So I need to create new column VP level and show Susan as VP for Alex
output need is
Any way to achieve this
The Hierarchy prefix might be useful to you.