Splunk Search

Split Single columns in equal multiple columns

jerinvarghese
Communicator

Hi All,

I have a code, that gives below output.

CODE: 

| inputlookup ONMS_nodes.csv
| table nodelabel

OUTPUT : 

nodelabel
LANCUA005
LANCUA008
LANCUA012
LANCUA014
LANCUA016
LANCUA018
LANCUA019
LANCUA020
LANCUA022
LANCUA023

 

This is a sample output. List can goes more than 600 or 700 devices. 

Requirement is like : 

Can we split this into multiple columns within the panel.

nodelabelnodelabel
LANCUA005LANCUA016
LANCUA008LANCUA018
LANCUA012LANCUA019
LANCUA014LANCUA020
LANCUA023LANCUA022

 

SO that the content can be used the whole single panel  page to display the entire content.

Labels (6)
0 Karma
1 Solution

tscroggins
Influencer

@jerinvarghese 

In SPL, you can count rows and columns and add xyseries to reformat by row/column:

| inputlookup ONMS_nodes.csv
| table nodelabel
| streamstats reset_after="rows==10" count as rows
| streamstats count as columns
| eval columns=floor((columns-1)/10)
| xyseries rows columns nodelabel
| sort rows
| fields - rows

 In this example, the columns (fields) are labeled 0, 1, 2, ..., 9. You can't give multiple fields the same label, but you can prefix them with "nodelabel" to make them a little more descriptive:

| inputlookup ONMS_nodes.csv
| table nodelabel
| streamstats reset_after="rows==10" count as rows
| streamstats count as columns
| eval columns=floor((columns-1)/10)
| xyseries rows columns nodelabel
| sort rows
| fields - rows
| foreach * [ rename <<FIELD>> as nodelabel_<<FIELD>> ]

 

View solution in original post

0 Karma

tscroggins
Influencer

@jerinvarghese 

In SPL, you can count rows and columns and add xyseries to reformat by row/column:

| inputlookup ONMS_nodes.csv
| table nodelabel
| streamstats reset_after="rows==10" count as rows
| streamstats count as columns
| eval columns=floor((columns-1)/10)
| xyseries rows columns nodelabel
| sort rows
| fields - rows

 In this example, the columns (fields) are labeled 0, 1, 2, ..., 9. You can't give multiple fields the same label, but you can prefix them with "nodelabel" to make them a little more descriptive:

| inputlookup ONMS_nodes.csv
| table nodelabel
| streamstats reset_after="rows==10" count as rows
| streamstats count as columns
| eval columns=floor((columns-1)/10)
| xyseries rows columns nodelabel
| sort rows
| fields - rows
| foreach * [ rename <<FIELD>> as nodelabel_<<FIELD>> ]

 

0 Karma
Get Updates on the Splunk Community!

Security Professional: Sharpen Your Defenses with These .conf25 Sessions

Sooooooooooo, guess what. .conf25 is almost here, and if you're on the Security Learning Path, this is your ...

First Steps with Splunk SOAR

Our first step was to gather a list of the playbooks we wanted and to sort them by priority.  Once this list ...

How To Build a Self-Service Observability Practice with Splunk Observability Cloud

If you’ve read our previous post on self-service observability, you already know what it is and why it ...