Hi Team,
how to Sum of the field based on the other field values.
Row1 field values will be 0-9 and a-z.
Sample one given below:
ROW1 | ROWcount |
11 | 22 |
12 | 54 |
13 | 34 |
a1 | 56 |
a2 | 78 |
d3 | 67 |
c4 | 78 |
c5 | 79 |
Final Output be like:
ROW1 | ROWcount |
1 | 110 |
a | 134 |
d | 67 |
c | 157 |
Thanks in Advance!!
Here is one of perhaps many ways to do that. It extracts the first letter of ROW1 as the new ROW1 value and the adds the ROWcount values with matching ROW1 values.
| rex field=ROW1 "(?<ROW1>.)"
| stats sum(ROWcount) as ROWcount by ROW1
Here is one of perhaps many ways to do that. It extracts the first letter of ROW1 as the new ROW1 value and the adds the ROWcount values with matching ROW1 values.
| rex field=ROW1 "(?<ROW1>.)"
| stats sum(ROWcount) as ROWcount by ROW1
Logic was worked. Thank you so much