# Get unique record(fields)

**URL:** <https://discuss.elastic.co/t/get-unique-record-fields/18054>\
**Category:** Elasticsearch\
**Created:** [June 11, 2014, 9:43pm UTC](https://discuss.elastic.co/t/get-unique-record-fields/18054 "2014-06-11T21:43:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![srikanth\_ramineni](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@srikanth\_ramineni](https://discuss.elastic.co/u/srikanth_ramineni)\
**Post date:** [June 11, 2014, 9:43pm UTC](https://discuss.elastic.co/t/get-unique-record-fields/18054/1 "2014-06-11T21:43:31Z")

</div>

Hi,

I have requirement to get unique fields from elastic search. Can somebody  
help me how can i get . Below is the scenario

Records  
product service sku  
xx min mx create

WSA-AMM-LIC-R= WAMMR WSA-AMM-1Y-S7-R1 PRODUCT 10 36 Procedure  
WSA-AMM-LIC-R= WAMMR WSA-AMM-1Y-S5-R2 PRODUCT 30 36 Procedure  
WSA-AMM-LIC-R= WAMMR WSA-AMM-1Y-S12-R PRODUCT 40 36 Procedure  
WSA-AMM-LIC-R= WAMMR WSA-AMM-3Y-S8-R3 PRODUCT 36 60 Procedure  
WSA-AMM-LIC-R= WAMMR WSA-AMM-5Y-S1-R4 PRODUCT 60 61 Procedure

Input will be WSA-AMM-LIC-R= , WAMMR and i am expecting the out only  
one row (having two fileds product and service level)

WSA-AMM-LIC-R= WAMMR

Thanks,  
srikanth.

--  
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/c728424a-d87b-40b6-a966-ffbe4ea2303e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/c728424a-d87b-40b6-a966-ffbe4ea2303e%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, 1:23am UTC](https://discuss.elastic.co/t/get-unique-record-fields/18054/2 "2017-07-06T01:23:10Z")

</div>


