Splunk Search

showing null values in a lookup table

rdevine
Path Finder

I have lines in multiple lookup tables that look like

lista,listb,listc,listd
a1,,c1,d1
,,b2,c2,d2
a3,b3,c3,d3

when i do a lookup on these and try to show all of the results it just eats up the lines in the table so i see

a1,b2,c1,d1
a3,b3,c2,d2
empty,empty,c3,d3

is there a way to configure lookup tables to populate a value even if there is nothing there?

Tags (1)

gvhees
Explorer

Hi,

Yes, you can use the "fillnull"command like:

|| fillnull value="empty"

the output should now show:
a1,empty,c1,d1
empty,b2,c2,d2
a3,b3,c3,d3

Hope it helps.

Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...