@Marco Wedel 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
jlh-QlikViewInquiry.xlsx 522.2 K