Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Possible to attach your sample file?
There is a hierarchy prefix for load statements that you could use.
Regards
Marco
@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