All Apps and Add-ons

classic SQL pivot in splunk

andreafebbo
Communicator

Hi
I need to do a classic pivoting in splunk but I cannot find a solution.

I have the first table in the following image and it have to become like the second table.

Of course the families and the name are dinamically generated at run time.
The columns 1st rank, 2nd rank and 3rd rank can have a fixed name.

alt text

Thanks a lot

1 Solution

renjith_nair
Legend

Try this

<your base search to result first table> |xyseries family rank name

OR

<your base search to result first table>|chart values(name) over family by rank
---
What goes around comes around. If it helps, hit it with Karma 🙂

View solution in original post

renjith_nair
Legend

Try this

<your base search to result first table> |xyseries family rank name

OR

<your base search to result first table>|chart values(name) over family by rank
---
What goes around comes around. If it helps, hit it with Karma 🙂

andreafebbo
Communicator

This is exactly what I needed!
Thanks a lot!

0 Karma
Get Updates on the Splunk Community!

How to send events & findings from AWS to Splunk using Amazon EventBridge

Amazon EventBridge is a serverless service that uses events to connect application components together, making ...

Exciting News: The AppDynamics Community Joins Splunk!

Hello Splunkers,   I’d like to introduce myself—I’m Ryan, the former AppDynamics Community Manager, and I’m ...

The All New Performance Insights for Splunk

Splunk gives you amazing tools to analyze system data and make business-critical decisions, react to issues, ...