Splunk Search

Combine fields into new field without NULL

arrowecssupport
Communicator

From our data we end up with 2 different fields v7serial & v8serial. I want to be able to feed this into a single serial v78serial.

Example of data
v7serial
987654321

v8serial
123456789

v78serial
123456789
987654321

I am trying

| eval v78serial= toString(v8serial) + ";" + toString(v7serial)
| makemv delim=";" allserials
| mvexpand v78serial | table v78serial

The problem is when i display this data or try to use this field i get "123456789;null" this is because the data has either a v7 or v8 serial never both. So where one field is Null then don't add it to the new field.

Tags (2)
0 Karma
1 Solution

somesoni2
Revered Legend

Try like this

your base search | eval v78serial=coalesce(v8serial,v7serial,"")  | table v78serial

View solution in original post

somesoni2
Revered Legend

Try like this

your base search | eval v78serial=coalesce(v8serial,v7serial,"")  | table v78serial
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...