I havea a search that gives me the below:
_time A B C D
1 2016-01-01 1 3 5 7
2 2016-01-02 1 3 5 7
3 2016-01-03 1 3 5 7
4 2016-01-04 1 3 5 7
5 2016-01-05 1 3 5 7
6 2016-01-06 1 3 5 7
7 2016-01-07 1 3 5 7
8 2016-01-08 1 3 5 7
Can I change the values of a specific column, lets say column D, from the dates 2016-01-02 to 2016-01-07 to different numbers for each date, for simplicity
lets say 2,3,4,5,6,7?
This way I will get:
_time A B C D
1 2016-01-01 1 3 5 7
2 2016-01-02 1 3 5 2
3 2016-01-03 1 3 5 3
4 2016-01-04 1 3 5 4
5 2016-01-05 1 3 5 5
6 2016-01-06 1 3 5 6
7 2016-01-07 1 3 5 7
8 2016-01-08 1 3 5 7
I have asked a similar question like this before here -
https://answers.splunk.com/answers/233206/how-to-control-values-of-a-field-relative-to-the-v.html
which involves eval tcheck=strptime("2015-04-29","%F") | eval test=if(_time<=tcheck,450,600) which I think I could use but it might become a bit verbose.
Can anyone advise if there is a better way?
... View more