Lookup csv file different code with same meaning

indeed_2000 — Wed, 20 Oct 2021 12:20:20 GMT

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

Re: Lookup csv file different code with same meaning

ITWhisperer — Wed, 20 Oct 2021 12:34:18 GMT

| lookup codes.csv | stats values(code) as code count by meaning | eval code=mvjoin(code,",")