classic SQL pivot in splunk

[andreafebbo]

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.

Thanks a lot

[renjith_nair · Accepted solution]

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

[andreafebbo]

This is exactly what I needed!
Thanks a lot!