unique filter sort 2

[dwcasey]

I have two columns of data. First is servername, second is issue found.

It so happens that the way I retrieved this data ( unix korn shell script ) will create a servername & issue for each issue found:

serv01 resolv.conf issue
serv01 no /tmp/echo file found
serv01 cannot ping backup
serv02 cannot ping backup
serv03 no /tmp/echo file found
serv03 cannot ping backup

What I would like to do is simply compile a list of server and issues found. Any thoughts on how to do this?

Thank you.

 

[AnotherHiggins]

-> What I would like to do is simply compile a list of server and issues found.

That's what you have.

Do you want a list of servers and a COUNT of issues found for each? If so, have a look at pivot tables.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

Hi,

Put headings on your columns and then use the PiovtTable Wizard to summarize.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[AnotherHiggins]

Oh! another thought - if you are trying to filter out duplicate rows (let's say "cannot ping backup" was recorded against serv01 3 times and you just want to see it once), then go to Data > Filter > Advanced Filter > Unique Records Only.

And, as Skip pointed out, add in a header row.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[dwcasey]

ahhh, very nice, pivot table is just what I needed, thank you.

 

[dwcasey]

The Advanced Filter, Unique is not working correctly. So I have

Server Issue
serv01 resolv.conf issue
serv01 no /tmp/echo file found
serv01 cannot ping backup
serv02 cannot ping backup
serv03 no /tmp/echo file found
serv03 cannot ping backup

And I give it the whole set for List Range, for criteria, I tried just the first column, copy to other cells in spreadsheet and check unique. It looks like an exact copy.

 

[SkipVought]

Is there a question in there? If there is, exactly WHAT do you expect to see, given the table you posted?

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[AnotherHiggins]

I offered that up because I wasn't sure what you were looking for. Like I said - Unique Records is to filter out identical records (all columns of a row are the same). In your case, this would be to filter our multiple occurrences of one issue against the same server.

Example:

If you started with:
[tt]
Server Issue[!]
serv01 resolv.conf issue[/!]
serv01 no /tmp/echo file found[!]
serv01 resolv.conf issue
serv01 resolv.conf issue[/!]
serv01 cannot ping backup
serv02 cannot ping backup[!]
serv01 resolv.conf issue
serv01 resolv.conf issue
serv01 resolv.conf issue[/!]
serv03 no /tmp/echo file found
serv03 cannot ping backup[/tt]

Then using the Advanced Filter > Unique would change it to:
[tt]
Server Issue[!]
serv01 resolv.conf issue[/!]
serv01 no /tmp/echo file found
serv01 cannot ping backup
serv02 cannot ping backup
serv03 no /tmp/echo file found
serv03 cannot ping backup[/tt]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[dwcasey]

Pivot table worked. I just needed a way to group multiple issues related to a single server.