Unfold HR Hierarchy

[BenGM]

Hi!

I am looking for some advise on extracting relationships within a HR hierarchy. This is a problem I know how to resolve with code but I just want to understand if I am missing any solution to this using the visual recipes that exist.

Below are sample input and outputs...

Before

Employee	Manager
Brian	James
James	Sarah
Lewis	Mary
Harry	Lewis
Charlotte	Sarah

After

Employee	Manager	Level
Brian	James	1
Brian	Sarah	2
James	Sarah	1
Harry	Lewis	1
Harry	Mary	2
Charlotte	Sarah	1
Lewis	Mary	1

Thanks!

BenGM

[Turribeach]

Personally I prefer to handle hierarchical queries in SQL as they tend to run much faster than in code. Obviously you may or may not have a SQL engine to use. Besides that I don't think any visual recipe will be able to do this.