Group-object

• schleep

  SSChampion

  Points: 12585

  More actions

  September 5, 2017 at 8:23 am

  #332463

  This should be simple, but I'm having trouble with suming values across groups:

  $a = @()
$b = New-Object pscustomobject -property @{TypeName = "Type A"; TypeId = "12"; Calls = 43}
$a += $b
$b = New-Object pscustomobject -property @{TypeName = "Type A"; TypeId = "12"; Calls = 12}
$a += $b
$b = New-Object pscustomobject -property @{TypeName = "Type B"; TypeId = "34"; Calls = 11}
$a += $b
$b = New-Object pscustomobject -property @{TypeName = "Type B"; TypeId = "34"; Calls = 17}
$a += $b

  $a gives
TypeId TypeName  Calls
------ -----    -----
12     Type A    43
12    Type A    12
34    Type B    11
34    Type B    17

  I want to group by TypeId, TypeName to get
  
TypeId TypeName Calls
------ ----- -----
12  Type A    55
34  Type B    28


  When I do

  $Data2 = $Data | Group-Object -Property TypeName, TypeId|
        %{New-Object psobject -Property @{
                                            Item = $_.Name
                                            nCalls = ($_.Group | Measure-Object nCalls -Sum).Sum
                                            }
        }
  i get
  Item          nCalls
12, Type A    55
34, Type B    28


  How can I get the original properties as columns?
  

• schleep

  SSChampion

  Points: 12585

  More actions

  September 5, 2017 at 12:19 pm

  #1958163

  Found the solution here: https://stackoverflow.com/questions/30769809/powershell-group-by-multiple-properties
  Clunky...