PS: Filter selected rows with only max values as output?

Question

I have a variable results ($result) of several rows of data or object like this:

PS> $result | ft -auto;
name   value
----   -----
a          1
a          2
b          30
b          20
....

what I need to get all the rows of name and max(value) like this filtered output:

PS> $result | ? |ft -auto
name   value
----   -----
a          2
b          30
....

Not sure what command or filters available (as ? in above) so that I can get each name and only the max value for the name out?

Shay Levy · Accepted Answer · 2010-05-12 21:29:50Z

4

$result | group name | select name,@{n='value';e={ ($_.group | measure value -max).maximum}}

answered May 12, 2010 at 21:29

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Keith Hill · Accepted Answer · 2010-05-05 23:42:33Z

3

This should do the trick:

PS> $result | Foreach {$ht=@{}} `
                      {if ($_.Value -gt $ht[$_.name].Value) {$ht[$_.Name]=$_}} `
                      {$ht.Values}

This is essentially using the Begin/Process/End scriptblock parameters of the Foreach-Object cmdlet to stash input objects with a max value based on a key into a hashtable.

Note: watch out for extra spaces after the line continuation character (`) - there shouldn't be any.

answered May 5, 2010 at 23:42

Keith Hill

204k44 gold badges370 silver badges377 bronze badges

2 Comments

David.Chu.ca Over a year ago

nice solution for the case in my Q by using hash-table. My Q is actually a simplified one. Not sure if this S would apply to the case with additional columns (name, value, tag, ...).

Keith Hill Over a year ago

It depends. If you can "key" off a single column name for testing for a max value then it should work fine. Keep in mind that the hashtable stores the original object so all the fields are preserved.

Collectives™ on Stack Overflow

PS: Filter selected rows with only max values as output?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related