topic Creating hierarchy from simplified personnel file... in QlikView

Creating hierarchy from simplified personnel file...

Fri, 18 Jul 2014 19:23:38 GMT

I have a very simple personnel file which lists EMP#, EMPName, MGR1# and MGR1Name for everyone in the company. From just this data, how can I then look-up the MGR# and use it as the EMP# to gain that person's MGR# and MGRName? I keep getting circular references or synthetic keys. FYI, I need 4 levels of MGRs so I will need to repeat the process and change the result to MGR5# and MGR5Name.

Re: Creating hierarchy from simplified personnel file...

Fri, 18 Jul 2014 20:19:30 GMT

Possible to attach your sample file?

Re: Creating hierarchy from simplified personnel file...

MarcoWedel — Sat, 19 Jul 2014 08:26:40 GMT

There is a hierarchy prefix for load statements that you could use.

Regards

Marco

Re: Creating hierarchy from simplified personnel file...

MarcoWedel — Sat, 19 Jul 2014 08:40:20 GMT

Re: Creating hierarchy from simplified personnel file...

Sun, 20 Jul 2014 21:46:26 GMT

@MarcoWedel The concept you post about is amazing, but I've spent my entire Sunday attempting to modify this code to work and it just doesn't sing. I do not get errors but I do get synthetic keys for employee and manager, and I can't seem to get a full 4 levels of management

Also, I already have my own employeeID and I can understand where AutoNumber come into play, but I cannot get my employeeIDs to be allowed into the table.

Yea, I'm new, and, I have a headache Here's hoping you can help tweak it!

I've included in the attached file are the following tabs:

Results: What I am expecting to come close to

PersonnelFile: Limited names in current format to complete 2 samples of 4 and 5 level management

TableView: just that, a pic of my tables

ScriptExport: just that, an export of my current script