# Elastic search representing value as key while creating the index using river

**URL:** <https://discuss.elastic.co/t/elastic-search-representing-value-as-key-while-creating-the-index-using-river/20513>\
**Category:** Elasticsearch\
**Created:** [October 31, 2014, 12:33pm UTC](https://discuss.elastic.co/t/elastic-search-representing-value-as-key-while-creating-the-index-using-river/20513 "2014-10-31T12:33:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Phani\_Nadiminti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/phani_nadiminti/32/45381_2.png) [@Phani\_Nadiminti](https://discuss.elastic.co/u/Phani_Nadiminti)\
**Post date:** [October 31, 2014, 12:33pm UTC](https://discuss.elastic.co/t/elastic-search-representing-value-as-key-while-creating-the-index-using-river/20513/1 "2014-10-31T12:33:59Z")

</div>

Hi All,

I have a scenario like following.

i have field in database table called "tempprop1" it contains value like  
"frontwheels : 50" etc .. like following.

## table:

tempprop1 tempprop2

frontwheels : 50 backwheels: 20  
headgear : 2 gear type : 2

```
         When i index the data using river straight forward query it is 

```

indexing as follows.  
tempprop1 : frontwheels : 50 ,  
tempprop2 : backwheels: 20.

```
            but for our index search convenience we want to index the 

```

value (frontwheels : 50) for tempprop1 field like following

frontwheels : 50  
backwheels : 20

```
    it needs to be index with value. now my question can we achieve 

```

this scenarios using river query (like bracket notation) to elastic search  
index .please suggest me how to handle this index creation using above  
requirements.  
please help me in this.

thanks

phani.

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/e11acb77-00e3-4a1a-ba7d-386614a60416%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/e11acb77-00e3-4a1a-ba7d-386614a60416%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<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:** [July 6, 2017, 12:52am UTC](https://discuss.elastic.co/t/elastic-search-representing-value-as-key-while-creating-the-index-using-river/20513/2 "2017-07-06T00:52:50Z")

</div>