Splunk Search

How to hide duplicate values in consecutive table rows?

HarAtWork
Explorer

Hello! If I have this:

Letter Number
A 1
A 2
A 3
B 1
B 2

 

is there a way to get this:

 

Letter Number
A 1
  2
  3
B 1
  2

 

so that the transition from one set of related rows to the next is clear?

 

 

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Interesting question.  Most people want to fill in blanks so Splunk offers the fillnull and filldown commands.  There are no commands for the reverse, however.

You can accomplish the task using streamstats to count the rows by Letter and eval to replace the Letter with an empty string for all but the first row for each Letter.

| streamstats count by Letter
| eval Letter=if(count==1, Letter, "")

 

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

Interesting question.  Most people want to fill in blanks so Splunk offers the fillnull and filldown commands.  There are no commands for the reverse, however.

You can accomplish the task using streamstats to count the rows by Letter and eval to replace the Letter with an empty string for all but the first row for each Letter.

| streamstats count by Letter
| eval Letter=if(count==1, Letter, "")

 

---
If this reply helps you, Karma would be appreciated.

HarAtWork
Explorer

That worked nicely, thank you!

Get Updates on the Splunk Community!

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Index This | What goes away as soon as you talk about it?

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

What's New in Splunk Observability Cloud and Splunk AppDynamics - May 2025

This month, we’re delivering several new innovations in Splunk Observability Cloud and Splunk AppDynamics ...