Unfold HR Hierarchy

BenGM
BenGM Registered Posts: 1

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

EmployeeManager
BrianJames
JamesSarah
LewisMary
HarryLewis
CharlotteSarah

After

EmployeeManagerLevel
BrianJames1
BrianSarah2
JamesSarah1
HarryLewis1
HarryMary2
CharlotteSarah1
LewisMary1


Thanks!

BenGM

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,024 Neuron

    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.

Setup Info
    Tags
      Help me…