topic Re: What's causing the error "Duplicate values causing conflict" on my multi search input box? in Dashboards & Visualizations

What's causing the error "Duplicate values causing conflict" on my multi search input box?

patricianaguit — Fri, 20 Apr 2018 09:07:44 GMT

I'm getting an error on my multi search input box. It says "Duplicate values causing conflict"
Below is my code

<form>
  <label>token trial</label>
  <fieldset submitButton="false">
    <input type="dropdown" token="view_token">
      <label>Views</label>
      <fieldForLabel>Views</fieldForLabel>
      <fieldForValue>Views</fieldForValue>
      <search>
        <query>index="ape_idx" sourcetype="ape_csv"  | lookup geo_region "Dominant Geographic Unit" as "Geographic Unit" outputnew "Geographic Region"   | dedup "Geographic Region" "GDN Account Group", "Operating Group" "Service Group" "Interaction Style" | table "Geographic Region" "GDN Account Group", "Operating Group" "Service Group" "Interaction Style" | transpose 0  | rename column AS Views | table Views</query>
        <earliest>0</earliest>
        <latest></latest>
      </search>
    </input>
    <input type="multiselect" token="test_tok">
      <label>Selection</label>
      <prefix>(</prefix>
      <suffix>)</suffix>
      <valuePrefix>Selection="</valuePrefix>
      <valueSuffix>"</valueSuffix>
      <delimiter> OR </delimiter>
      <fieldForLabel>"$view_token$"</fieldForLabel>
      <fieldForValue>"$view_token$"</fieldForValue>
      <search>
        <query>index="ape_idx" sourcetype="ape_csv" 
| lookup geo_region "Dominant Geographic Unit" as "Geographic Unit" outputnew "Geographic Region" 
| dedup "Geographic Region" "GDN Account Group", "Operating Group" "Service Group" "Interaction Style" 
| sort "Geographic Region" "GDN Account Group", "Operating Group" "Service Group" "Interaction Style" 
| table "Geographic Region" "GDN Account Group", "Operating Group" "Service Group" "Interaction Style" 
| transpose 
| rename column AS Views 
| table Views 
| where Views="$view_token$"
| append 
    [| search index="ape_idx" sourcetype="ape_csv" 
    | lookup geo_region "Dominant Geographic Unit" as "Geographic Unit" outputnew "Geographic Region" 
    | dedup"Geographic Region" "GDN Account Group", "Operating Group" "Service Group" "Interaction Style" 
    | sort "Geographic Region" "GDN Account Group", "Operating Group" "Service Group" "Interaction Style" 
    | table "$view_token$"]</query>
        <earliest>0</earliest>
        <latest></latest>
      </search>
    </input>
  </fieldset>
</form>

Re: What's causing the error "Duplicate values causing conflict" on my multi search input box?

kmaron — Fri, 20 Apr 2018 17:22:31 GMT

I'd start by running the query you're using to build your multi-select information and see if there are duplicates. If there are then you'll need to dedup them.

Re: What's causing the error "Duplicate values causing conflict" on my multi search input box?

woodcock — Sun, 22 Apr 2018 20:55:27 GMT

I agree with @kmaron; you have duplicate values which is not allowed. Run the search manually and figure out why and fix your populating search.

Re: What's causing the error "Duplicate values causing conflict" on my multi search input box?

patricianaguit — Mon, 23 Apr 2018 01:17:35 GMT

Thanks for the help!

Re: What's causing the error "Duplicate values causing conflict" on my multi search input box?

patricianaguit — Mon, 23 Apr 2018 01:18:14 GMT

Thanks for the help!

Re: What's causing the error "Duplicate values causing conflict" on my multi search input box?

Shan — Mon, 23 Apr 2018 05:57:30 GMT

I agree with the command of @kmaron and @ Woodcock. Here i want to make another point . Rather than using dedup as mentioned below. Try to narrow down the result which exactly required. Remove the unnecessary fields. So that can even minimize the duplication of records ..

| dedup"Geographic Region" "GDN Account Group", "Operating Group" "Service Group" "Interaction Style"

Re: What's causing the error "Duplicate values causing conflict" on my multi search input box?

niketn — Mon, 23 Apr 2018 06:59:26 GMT

@patricianaguit, I have converted @kmaron's comment to answer. If your issue is resolved please accept to mark this question as answered. Do up vote the comments that helped 🙂