Hi I have csv file that contain my errorcodes and meaning of them. I import this csv as lookup.
the problem is some codes have same meaning and when I get report show them separately
e.g
Here is the my csv:
code meaning
404 Page not found
402 Page not found
Current output:
Code Meaning Count
404 Page not found 25
402 Page not found 25
I need to consider them as one and count them like this:
Code Meaning TotalCount
404, 402 Page not found 50
FYI: if meaning are same consider they are same and able to count them
any idea?
Thanks
| lookup codes.csv
| stats values(code) as code count by meaning
| eval code=mvjoin(code,",")
| lookup codes.csv
| stats values(code) as code count by meaning
| eval code=mvjoin(code,",")