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!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...