Split Single columns in equal multiple columns

[jerinvarghese]

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.

nodelabel	nodelabel
LANCUA005	LANCUA016
LANCUA008	LANCUA018
LANCUA012	LANCUA019
LANCUA014	LANCUA020
LANCUA023	LANCUA022

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

[tscroggins · Accepted solution]

@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>> ]