How do I add a CDM List (An .xlsx file) to a look up list in Splunk Ent. ? Thank u very much

SamHTexas — Wed, 15 Sep 2021 20:49:54 GMT

Please share the process of adding an .xlsx file to a Lookup list in Splunk Enterprise. Thank you a bunch.

Re: How do I add a CDM List (An .xlsx file) to a look up list in Splunk Ent. ? Thank u very much

solarboyz1 — Wed, 15 Sep 2021 21:27:47 GMT

First, you will need to open you .xlsx file in Excel and save it as CSV.

Then settings -> lookups -> Lookup Table File -> New Lookup Table File and upload your CSV file.

Now to combine your new lookup table file, by appending the new to the bottom of the current:

| inputlookup new_lookup.csv
| outputlookup append=t current_lookup

Which will append the entries of the csv you just uploaded to the bottom of your current CSV.

topic Re: How do I add a CDM List (An .xlsx file) to a look up list in Splunk Ent. ? Thank u very much in Splunk Enterprise

How do I add a CDM List (An .xlsx file) to a look up list in Splunk Ent. ? Thank u very much

Re: How do I add a CDM List (An .xlsx file) to a look up list in Splunk Ent. ? Thank u very much