How to Create parent child relation of the data in Department Table

[Anurag Tripathi]

Hi,

Generally Parent ORG is used to map multiple departments, but if you want nested departments then on the Department table you will have to add a new field called Parent Department, this field will be a reference field to the same department table.

After you have done this, you can add the Department -> Parent department related list to the form.

[Silent]

Like i am receiving excel data where i have multiple columns in which 6th column is a child and 5th is its parent, 4th is parent of 5th and likewise till 1st 

how to achieve this by script??

[Anurag Tripathi]

Basically each row will have a child and a parent. some rows will be parent only.

Transform map will be able to handle it, You don't need any script.