Splunk Search

how to make eval function to work for mutivalued fields ..... to display

dilstn
Explorer

Here is the eval function which i use in particular field (which is a multivalued field) and then this value n display only for the first value of field....can u guide me to get the other value for the multivalued field .....

.......|eval n=if(isint(field1),"yes","no")| table sno,field1,n

sno field1 n
1 102 yes
132
234
P21
PSP

so for the remaining field1 value the eval function doesnt show the value.....

so i need like this...

Sno field1 n
1 102 yes
132 yes
234 yes
PGT no
PSP no

Tags (1)
0 Karma

kristian_kolb
Ultra Champion

Perhaps the following may help;

mvexpand - make several events out of an event with a multivalued field (one for each value)

http://docs.splunk.com/Documentation/Splunk/5.0.2/SearchReference/Mvexpand

the mv* functions for eval, e.g. mvindex() and mvfilter() - see the examples

http://docs.splunk.com/Documentation/Splunk/5.0.1/SearchReference/CommonEvalFunctions

/Kristian

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Rounding off the Splunk Dashboard Contest

What does a contest-winning Splunk dashboard look like? In this case, it isn't in a browser tab at all. It ...

A Four Part Event Series: AI + Observability: AI Agents, LLMs, Apps, & Infrastructure

AI + Observability: AI Agents, LLMs, Apps, & Infrastructure The rapid evolution of artificial intelligence ...