Duplicate values on dropdown multiselect input

[MeMilo09]

Hello All,

I keep getting duplicates on my values for multiselect dropdown. I made sure my fields were correct the - field for name and field for values and query on the search.  Not sure what else I need to check for. My source below... Any advise is welcome. 

<input type="multiselect" token="tok_space_name" searchWhenChanged="true">

      <label>Select Space</label>

      <choice value="*">All</choice>

      <default>*</default>

      <prefix>(</prefix>

      <suffix>)</suffix>

      <valuePrefix>space_name="</valuePrefix>

      <valueSuffix>"</valueSuffix>

      <delimiter> OR </delimiter>

      <fieldForLabel>Select Space</fieldForLabel>

      <fieldForValue>space_name</fieldForValue>

      <search>

        <query>index="lll_soruceIdx.idx"  | stats values(space_name) as space_name | mvexpand space_name</query>

        <earliest>$time_range.earliest$</earliest>

        <latest>$time_range.latest$</latest>

      </search>

[bowesmana]

Your '<fieldForLabel> should be a field in the data from your search to use as the visible dropdown, not the text

'Space Label', so change it to space_name

Also your search is probably better as

index="lll_soruceIdx.idx" 
| stats count by space_name 

so you don't first collapse all spaces and then expand them again.

[vikasjha001]

Could you try adding below command as well in the end of the search query. This should remove any duplicate entries for space_name

| dedup space_name 

Regards,

Vikas Jha