Splunk Search
×

Join the Conversation

Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
Ask a Question

lookup - append only columns with values

fedejko
Explorer
‎09-29-2021 05:06 AM

Hi,

I've got a lookup with a number of records, and not all of them have all columns populated. Is there a way to append only those columns which are not empty?

Something similar to:

 

| lookup mylookup lookup_key OUTPUTNEW list of columns to append
| <some SPL here to hide columns which are empty>

 

I'd be grateful for any tips.  I was experimenting with foreach but with no results.

Regards

Labels (1)
Labels
0 Karma
Reply
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Event Series: Level up your SOC: Advancing with Splunk Enterprise Security

AI has fundamentally raised the stakes for security operations, and this three-part series is your guide to ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...