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 just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...