Splunk Search

How to append data to a lookup without overwriting anything AND also not adding duplicate data entries into the lookup?

Robbie1194
Communicator

Hi guys,

I was wondering if anyone knew of a method of appending data to a lookup, but not overwriting anything in the lookup AND also not adding duplicate data entries into the lookup?

Any suggestions would be helpful.

Cheers,
Robbie

0 Karma
1 Solution

FritzWittwer_ol
Contributor
| inputlookup <table>
| append [makeresults | eval .... | fields - _time]
| dedup <keyfield>
| outputlookup <table> append=false

View solution in original post

comjb
Loves-to-Learn Lots

Another way to do it:

0 Karma

FritzWittwer_ol
Contributor
| inputlookup <table>
| append [makeresults | eval .... | fields - _time]
| dedup <keyfield>
| outputlookup <table> append=false
Get Updates on the Splunk Community!

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

[Puzzles] Solve, Learn, Repeat: Nested loops in Event Conversion

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Your Guide to Splunk Digital Experience Monitoring

A flawless digital experience isn't just an advantage, it's key to customer loyalty and business success. But ...