Archive

How to change table column headings?

Path Finder

The search command that I have used is:
| chart list(field1) as A list(field2) as B by name month

The result I am getting is something like this
Name A : JAN A : FEB A : MAR B : JAN B : FEB B : MAR
abc

xyz

Desired result:

NAME JAN : A JAN : B FEB : A FEB : B MAR : A MAR : B
abc

xyz

I know the reason why I am getting the result but is there any way to change the names like the desired one?
Thanks in advance.

0 Karma
1 Solution

SplunkTrust
SplunkTrust

hey try this

<your_base_query> | chart list(field1) as A list(field2) as B over name by month | rename A:* as *:A B:* as *:B 

let me know if this helps!

View solution in original post

SplunkTrust
SplunkTrust

hey try this

<your_base_query> | chart list(field1) as A list(field2) as B over name by month | rename A:* as *:A B:* as *:B 

let me know if this helps!

View solution in original post

Path Finder

Thank you,it worked.

0 Karma

Contributor

Try to use rename

[your_search] | rename "A:*" as "*:A", "B:*" as "*:B"

Path Finder

Thanks for the answer

0 Karma