Getting Data In

Duplicate labels causing conflict when importing Data from CSV for Dropdown Menu

curtisLJMU
New Member

Hello,

I am attempting to import data from a CSV file into a dropdown menu. In the CSV there is duplicate entries in the CUS_NAME column, however when I use the DEDUP function I can see in the results that the entries are no longer duplicated. When I put the below search into the drop down search string I get the error message "Duplicate labels causing conflict".

index="MYINDEX" host="MYHOST" source="MYSOURCE.csv" | dedup CUS_NAME

I am using Splunk Enterprise 6.2.2.

If you have any questions, please don't hesitate to ask.

Many thanks,
C

Tags (1)
0 Karma

alacercogitatus
SplunkTrust
SplunkTrust

Make sure you are specifying "CUS_NAME" as the <fieldForLabel> and <FieldForValuealue> fields of the drop down. Then, make your populating search this:

    index="MYINDEX" host="MYHOST" source="MYSOURCE.csv" | stats count by CUS_NAME

Stats is much more efficient in removing dedups.

0 Karma
Get Updates on the Splunk Community!

Splunk Security Content for Threat Detection & Response, Q1 Roundup

Join Principal Threat Researcher, Michael Haag, as he walks through:An introduction to the Splunk Threat ...

Splunk Life | Happy Pride Month!

Happy Pride Month, Splunk Community! &#x1f308; In the United States, as well as many countries around the ...

SplunkTrust | Where Are They Now - Michael Uschmann

The Background Five years ago, Splunk published several videos showcasing members of the SplunkTrust to share ...