# Return score in multiple fields **URL:** \ **Category:** Elasticsearch\ **Created:** [October 20, 2014, 9:57am UTC](https://discuss.elastic.co/t/return-score-in-multiple-fields/20333 "2014-10-20T09:57:57Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Kruti\_Shukla](https://avatars.discourse-cdn.com/v4/letter/k/45deac/32.png) [@Kruti\_Shukla](https://discuss.elastic.co/u/Kruti_Shukla)\ **Post date:** [October 20, 2014, 9:57am UTC](https://discuss.elastic.co/t/return-score-in-multiple-fields/20333/1 "2014-10-20T09:57:57Z")
Hello All, I'm trying achieve one functionality in Elasticsearch but I'm not able to do it. In SQL we can do it like --\> select SET score\_1 = \_score from sometable I trying to assign value of score in one field. That means Elastic search will return 2 columns having same values \_score and \_score1. I have already tried custom score but it changes the value of \_score column it self.I DO NOT WANT TO CHANGE . I'm already happy with the score returned in "\_score" field. I want to have same value of "\_score" column in another column for example "score\_1". I want to do same in Elasticsearch. Is it possible? Is there any functionality provided in elasticsearch? -- 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/a8a22823-593f-40f3-8ab6-eb6da2bc85c5%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/a8a22823-593f-40f3-8ab6-eb6da2bc85c5%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**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:55am UTC](https://discuss.elastic.co/t/return-score-in-multiple-fields/20333/2 "2017-07-06T00:55:05Z")