topic How do I get unique values in form dropdown? in Getting Data In https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87424#M18124 <P>I want the list in the dropdown to be unique values in a form.</P> <P>What do I have to put in the 'populatingSearch' element to make sure every value is unique?</P> Mon, 08 Jul 2013 15:59:53 GMT oriches 2013-07-08T15:59:53Z How do I get unique values in form dropdown? https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87424#M18124 <P>I want the list in the dropdown to be unique values in a form.</P> <P>What do I have to put in the 'populatingSearch' element to make sure every value is unique?</P> Mon, 08 Jul 2013 15:59:53 GMT https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87424#M18124 oriches 2013-07-08T15:59:53Z Re: How do I get unique values in form dropdown? https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87425#M18125 <P>Let's say your're populating the dropdown with hosts, you can dedup a few ways in Splunk.</P> <P>One way would be to dedup the field host:</P> <PRE><CODE>... | dedup host </CODE></PRE> <P>Another would be to use stats</P> <PRE><CODE>... | stats values(host) as host </CODE></PRE> <P>I generally use the dedup command in this situation: <A href="http://docs.splunk.com/Documentation/Splunk/5.0.3/SearchReference/Dedup">http://docs.splunk.com/Documentation/Splunk/5.0.3/SearchReference/Dedup</A></P> Mon, 08 Jul 2013 16:19:44 GMT https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87425#M18125 bwooden 2013-07-08T16:19:44Z Re: How do I get unique values in form dropdown? https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87426#M18126 <P>I tried '| dedup host' but it returned nothing...</P> Mon, 08 Jul 2013 16:20:36 GMT https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87426#M18126 oriches 2013-07-08T16:20:36Z Re: How do I get unique values in form dropdown? https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87427#M18127 <P>I got it to work with the following 'host | dedup host'</P> Mon, 08 Jul 2013 16:33:04 GMT https://community.splunk.com/t5/Getting-Data-In/How-do-I-get-unique-values-in-form-dropdown/m-p/87427#M18127 oriches 2013-07-08T16:33:04Z