I have a table with the following data
08 | 09 | 10 |
data | data | data |
data | data | data |
data | data | data |
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.
| transpose 0
| eval column=strftime(strptime("01-".column."-21","%d-%m-%y"),"%b%y")
| transpose 0 header_field=column
| fields - column
| transpose 0
| eval column=strftime(strptime("01-".column."-21","%d-%m-%y"),"%b%y")
| transpose 0 header_field=column
| fields - column
Thank you!
You've helped me a lot.