# Recommendation on multi level hierarchial structure with arrays

**URL:** https://discuss.elastic.co/t/recommendation-on-multi-level-hierarchial-structure-with-arrays/147255
**Category:** Elasticsearch
**Created:** [September 4, 2018, 7:02pm UTC](https://discuss.elastic.co/t/recommendation-on-multi-level-hierarchial-structure-with-arrays/147255 "2018-09-04T19:02:44Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![rohitgoel](https://avatars.discourse-cdn.com/v4/letter/r/e56c9b/32.png) [@rohitgoel](https://discuss.elastic.co/u/rohitgoel)
#### Post date: [September 4, 2018, 7:02pm UTC](https://discuss.elastic.co/t/recommendation-on-multi-level-hierarchial-structure-with-arrays/147255/1 "2018-09-04T19:02:44Z")

</div>

I have a complex data structure that I would want to index in Elastic.  
Its a multi level structure with arrays. What's the best way to model it ?

For example,

{  
"Organization": "MyOrg",  
"Business Units": [  
{  
"Name": "Sales",  
"Location": "SanJose",  
"Employees": [  
{  
"Name": "George",  
"Age": "50"  
},  
{  
"Name": "John",  
"Age": "30"  
}  
]  
},  
{  
"Name": "IT",  
"Location": "NewYork",  
"Employees": [  
{  
"Name": "Smith",  
"Age": "45"  
},  
{  
"Name": "Clark",  
"Age": "25"  
}  
]  
}  
]  
}

---

<div class="post-metadata">

### Author: ![jaddison](https://avatars.discourse-cdn.com/v4/letter/j/e5b9ba/32.png) [@jaddison](https://discuss.elastic.co/u/jaddison)
#### Post date: [September 10, 2018, 4:18am UTC](https://discuss.elastic.co/t/recommendation-on-multi-level-hierarchial-structure-with-arrays/147255/2 "2018-09-10T04:18:31Z")

</div>

- You should probably consider denormalizing your data somewhat.
- You might consider 'join' fields to relate Employee to BusinessUnit maybe (there's a fair bit to consider if you do this though, so tread lightly)

By the way, formatting your code so it's indented makes it a lot easier for others to parse it and provide help.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 8, 2018, 4:18am UTC](https://discuss.elastic.co/t/recommendation-on-multi-level-hierarchial-structure-with-arrays/147255/3 "2018-10-08T04:18:36Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
