How do I identify hashtable keys with multiple values in powershell

Question

I have a hashtable created from an array like this:

$employeesHashtable = $employees | Group-Object -Property Initials -AsHashTable

How do I find keys having multiple values?

Santiago Squarzon · Accepted Answer · 2022-05-31 16:58:26Z

2

The alternative to using .GetEnumerator() can be using the hash table Keys, the key collection implements ICollection and can be enumerated without issues:

$keysWithMultipleValues = $employeesHashtable.Keys.where{ $employeesHashtable[$_].Count -gt 1 }

answered May 31, 2022 at 16:58

Santiago Squarzon

65.6k5 gold badges26 silver badges60 bronze badges

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

Comments

mortenma71 · Accepted Answer · 2022-05-31 16:15:53Z

0

I ended up with this:

$keysWithMultipleValues = $employeesHashtable.GetEnumerator() | `
  ForEach-Object { [PSCustomObject]@{ Key = $_.Key; Count = $_.Value.Count } } | `
  Where-Object { $_.Count -gt 1 }

answered May 31, 2022 at 16:15

mortenma71

1,3162 gold badges11 silver badges30 bronze badges

2 Comments

Mathias R. Jessen Over a year ago

FWIW you can skip the ForEach-Object invocation completely: $employeesHashtable.GetEnumerator() |Where-Object { $_.Value.Count -gt 1 } (will likely be slightly faster)

Santiago Squarzon Over a year ago

If you're using .GetEnumerator() you should reverse the order for efficiency, first filter: $employeesHashtable.GetEnumerator() | Where-Object { $_.Value.Count -gt 1 } then construct your object

Collectives™ on Stack Overflow

How do I identify hashtable keys with multiple values in powershell

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