current I have this search:
......||addcoltotals | table *_August_R | reverse | head 1
1_Ausgust_R,2_Ausgust_R,3_Ausgust_R,4_Ausgust_R,
26 30 15 27
I want to change it to
Date, Number
1_August, 26
2_August, 30
3_August, 15
3_August, 27
Try this!
......|addcoltotals | table *_August_R | reverse | head 1
|transpose|rename column as Date,"row 1" as Number|eval Date=substr(Date,1,len(Date)-2)
Try this!
......|addcoltotals | table *_August_R | reverse | head 1
|transpose|rename column as Date,"row 1" as Number|eval Date=substr(Date,1,len(Date)-2)
1 more question now, if
......||addcoltotals | table *_August_R , *_August_A| reverse | head 1
1_Ausgust_R,2_Ausgust_R,3_Ausgust_R,4_Ausgust_R, 1_August_R , 2_August_R
26 30 15 27 5 20
want to do below
Date , Number, Another Number
1_August, 26, 5
2_August, 30, 20
.....
how do i use eval but base on other col