Splunk Search

how to create a record if missing

jiaqya
Builder

exmaple below

column1:column2
1:10
2:15
4:30
5:40

in this example, column1 is missing "3", i would like to create this record with a "0" value in column2.
how can this be done ?

thanks..

0 Karma

manjunathmeti
Champion

Use append:

<your search> | append [| makeresults | eval column1=3, column2=0]
0 Karma

jiaqya
Builder

this works if record does not exist, at times it ( column1=3) can exist as well..

0 Karma
Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Enhance Security Operations with Automated Threat Analysis in the Splunk EcosystemAre you leveraging ...

Splunk Developers: Go Beyond the Dashboard with These .Conf25 Sessions

  Whether you’re building custom apps, diving into SPL2, or integrating AI and machine learning into your ...

Index This | How do you write 23 only using the number 2?

July 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...