Splunk Enterprise

how to rename the dynamically generated month fields

lostcauz3
Path Finder

I have a table with the following data

080910
datadatadata
datadatadata
datadatadata

 

i want to rename the 08,09,10 to Aug21,Sep21 and Oct21

the field name can be anything from 01 to 12 

01 = Jan21 , 02 = Feb 21, 03 = March21 etc 

How can i rename them in this case.

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| transpose 0
| eval column=strftime(strptime("01-".column."-21","%d-%m-%y"),"%b%y")
| transpose 0 header_field=column
| fields - column

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| transpose 0
| eval column=strftime(strptime("01-".column."-21","%d-%m-%y"),"%b%y")
| transpose 0 header_field=column
| fields - column
0 Karma

lostcauz3
Path Finder

Thank you!

You've helped me a lot.

0 Karma
Get Updates on the Splunk Community!

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...