Splunk Search

Lookup Table as input for Dashboard

MarieHe
New Member

Hello,

I would like to enter the info from a lookup table into my dashboard search.

 

lookup table name: FIP.csv

content:

field1;field2

160;43

180;50

 

I tried this:

| inputlookup FIP.csv

and then several add-ons like

| lookup FIP field1 OUTPUTNEW field2

but nothing works.

 

What is the correct syntax?

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Have you added it to the list of lookups?

ITWhisperer_0-1629204877329.pngITWhisperer_1-1629204907721.png

 

0 Karma

MarieHe
New Member

Yes. And I can see it in "Datasets", too.

 

| inputlookup "NRCS2AUDI_FIP_Lookup_SOLL.csv"

is working but I cannot devide the two different columns with ; into two separate types

Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| eval field1=mvindex(split('field1;field2',";"),0)
| eval field2=mvindex(split('field1;field2',";"),1)
0 Karma
Get Updates on the Splunk Community!

Thanks for the Memories! Splunk University, .conf24, and Community Connections

Thank you to everyone in the Splunk Community who joined us for .conf24 – starting with Splunk University and ...

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...