# Create index in which one field as an Object of not same structure

**URL:** <https://discuss.elastic.co/t/create-index-in-which-one-field-as-an-object-of-not-same-structure/360593>\
**Category:** Elasticsearch\
**Created:** [May 31, 2024, 5:37am UTC](https://discuss.elastic.co/t/create-index-in-which-one-field-as-an-object-of-not-same-structure/360593 "2024-05-31T05:37:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Parameshwar\_Wankhede](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/parameshwar_wankhede/32/134956_2.png) [@Parameshwar\_Wankhede](https://discuss.elastic.co/u/Parameshwar_Wankhede)\
**Post date:** [May 31, 2024, 5:37am UTC](https://discuss.elastic.co/t/create-index-in-which-one-field-as-an-object-of-not-same-structure/360593/1 "2024-05-31T05:37:53Z")

</div>

So i need some suggestion , in my project there is existing sql table .in which i have some fields and one nested object. that nested object i am storing as json string and i am querying on that. and main thing is that object is 10 different structure any one of them can be used at a time to store.  
so now we want to change the database to Elasticsearch. for that i need some suggestion like how can i store the data by creating single index, or can i create multiple index for all 10 object and then add the table fields in all the objects. or create a single index. the most important this is that i want to run the query on that nested object for some nested field the objects are complex one