Hierarchy Levels wrong - Managers column no data

[Anonymous]

Hi All,

I have created Hierarchy Levels  with below code:

Hierarchy(EMP_ID,MGR_ID,[EMPLOYEE NAME],Parent,[EMPLOYEE NAME],PATH,'/',LEVEL)

LOAD

EMP_ID, MGR_ID ,[EMPLOYEE NAME]

Resident Employee;

In level 1 there should be only one employee, but its more than one, as lot of employees records don't have managers info populated in manager fields.

Because of missing managers, count of employees in all levels will be wrong.

Is there a way to force the employee's to desired levels,as manager columns data is missing.

Please any help will be appreciated.

Thanks & Regards

Neetha

[Anonymous]

Could you create a dummy Manager record and then, in your script, for rows with no Manager data add the dummy Manager data ?

[Anonymous]

Hi Bill,

Thanks for immediate response.

Creating dummy manager will not push the employee level to lower level.

because i want to push a employee level to below a existing employee in the hierarchy , depending on business unit,etc.

Thanks & Regards

Neetha

[Anonymous]

Could you share some sample data including the Business unit along with your desired output ?

[Anonymous]

Hi Bill,

Thanks ,but can't share, its sensitive data.

Is there a way to solve this,as its huge data,

at level 1 only 1 employee should be there but they are 475 employees.

Because of one level ,rest of the levels count is wrong hugely.

Regards

Neetha

[Anonymous]

Could explain what you mean by push a employee level to below a existing employee in the hierarchy , depending on business unit,etc.

As in what is your push algorithm ?

[MarcoWedel]

completing your data probably makes more sense than developing a sophisticated script that might or might not correct the output in some cases.

hope this helps

regards

Marco

[Anonymous]

Hi Bill,

Thanks for reply,

Push employee level to existing employee of same unit + Business level group 1  + Business level group 2.

other requirement is employee should be pushed to level 4 or lower than that level.

Push in the sense, level 4 or lower than that level employee id should be populated in empty manager id columns for employee at level 1.

Regards

Neetha

[Anonymous]

Hi Marco,

Thanks for reply.

Requested for Data cleansing in database. But it can't be done now.

can't help it.

Regards

Neetha