Splunk Search

consequence of lookup command with or without OUTPUT parameter

ankithreddy777
Contributor

What is the difference between with or without using OUTPUT parameter in lookup command.

Tags (1)
0 Karma

s2_splunk
Splunk Employee
Splunk Employee

From the documentation

Usage
When using the lookup command, if an OUTPUT or OUTPUTNEW clause is not specified, all of the fields in the lookup table that are not the match field are used as output fields. If the OUTPUT clause is specified, the output lookup fields overwrite existing fields. If the OUTPUTNEW clause is specified, the lookup is not performed for events in which the output fields already exist.

somesoni2
Revered Legend

Without OUTPUT it'll return all the fields from the lookup table.

Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...