Hi,
I have a table like this :
test | count |
test AA | 1 |
test AB | 2 |
test C | 3 |
I want to merge "test AA" and "test AB" which will give me a count of 3 together.
What I want :
test | count |
test A | 3 |
test C | 3 |
How Can I do that ?
The best answer will depend on the nature of the test field, but this is one way to do it.
... | eval test = substr(test,1,6)
| stats count by test