How to create Location Hierarchy?

chirag sorathi1
Kilo Contributor

Hi! Community. I am trying to store all addresses under one parent. I don't know how to create Location hierarchy. When I transfer address from excel sheet to target table all address store in location but I want to store them under one parent so I can identify that these all addresses belong to this department. 

 

I have attached example pic. In that example they store all addresses under the floor And I want to store my addresses under one unique company name. Please guide me. I really appriciate your help. Please tell me the steps, how can I create this kind of tree structure.

Cheers!

4 REPLIES 4

Ravi9
ServiceNow Employee
ServiceNow Employee

if you want to create hierarchy in location table , you will have to use oob parent field and set data accordingly , see examples in ur instance itself , the data which has proper hierarchy - what does their parent field has ! 

I am using transform map to transfer all addresses into location table. And, it work very well. I can see all transfered addresses into parent field. The problem is I don't know, how I can stroe them in one company name. For example, In my case, I have three companies A,B and C and each company has multiple employees. I add all employess addresses into location table. Now the problem is When you open location herarchy, I don't know which address belong to which company. So I want to make  three parent and then each address should be save into their relavent company. I hope you got my point. Please advice me how can I create Location Hierarchy. Please tell me the steps. And, what is oob?

its not completely clear to me but this is what i understand 

say you have company google and amazon 

when you search in location table with company google 

you should see all results of all hierarchy 

meaning if google offices in say santa clara and there are 2 branches 

you will see 2 results both of which has santa clara as parent 

something like that ? 

find_real_file.png

yes, I want to set parent and I don't know how to do it. Could you please help me with that?

I really appriciate your help. Thanks mate.