Powershell 阵列-合并同一位置

Question 1

类似这样的事情应该有效：

$result = @()

Function getIndex($location)
{
  for($j = 0; $j -lt $result.Count; $j++) {
    if($result[$j].Location -contains "$location") {
      $index=$j
      break;
    }
  }
  return $index
}

for ($i=0; $i -lt $outarray.length; $i++) {
  $loc=$outarray[$i].Location
  $aphones=$outarray[$i].'Analog Phones'
  $ipphones=$outarray[$i].'IP Phones'
  if(!($result | where-object {$_.Location -eq "$loc"})) {
    $result+=New-object psobject -property @{'Location' = "$loc"; 'Analog Phones' = $aphones; 'IP Phones' = $ipphones}  
    } else {
      $index=getIndex($loc) 
      $result[$index].'Analog Phones' = $result[$index].'Analog Phones' + $aphones
      $result[$index].'IP Phones' = $result[$index].'IP Phones' + $ipphones
   }
}
$result

$result输出为：

Analog Phones      IP Phones     Location
-------------      ---------     --------
          413            887     Site1
          192            333     Site2

逻辑如下：

Define an empty $result array to store final results
Iterate over $outarray
  each time a location is found
     if location does not exists in $result then
        add full line from $outarray into $result for this location

     if location already exists in $result then
        retrieve the index for the given location in $result
        update Analog Phones number in $result with values from $outarray + $result for the given location (index)
        update IP Phones number in $result with values from $outarray + $result for the given location (index)

PS：我不是 Powershell 专家，所以我认为getIndex可以改进。但是，根据您的源代码，它对我来说是有效的。

希望它能有所帮助！

编辑

以下是我将我的代码集成到您的代码中的方式：

首先我创建了$outarray像你这样的（我认为），除了我使用了硬编码值（而不是解析 xml 文件）：

$outarray  = @()
$outarray+=New-object psobject -property @{'Analog Phones' = 0;'IP Phones' = 883;'Location' = "Site1"}
$outarray+=New-object psobject -property @{'Analog Phones' = 413;'IP Phones' = 0;'Location' = "Site1"}
$outarray+=New-object psobject -property @{'Analog Phones' = 0;'IP Phones' = 4;'Location' = "Site1"}
$outarray+=New-object psobject -property @{'Analog Phones' = 0;'IP Phones' = 258;'Location' = "Site2"}
$outarray+=New-object psobject -property @{'Analog Phones' = 9;'IP Phones' = 75;'Location' = "Site2"}
$outarray+=New-object psobject -property @{'Analog Phones' = 183;'IP Phones' = 0;'Location' = "Site2"}

从这一点来看，我的$outarray样子是这样的：

Analog Phones    IP Phones    Location
-------------    ---------    --------
            0          883    Site1
          413            0    Site1
            0            4    Site1
            0          258    Site2
            9           75    Site2
          183            0    Site2

export-csv然后我在你的命令之后添加了我的代码：

$outarray | Sort-Object............

MY CODE HERE

编辑2

我发现您的实际代码存在问题：数字被解释为字符串，因此无法正确计算。您必须将它们转换为整数：

foreach($item in $finalxml){
  ...
  ...
  $outarray+=New-object psobject -property @{
        'Analog Phones' = [int]$item.analog_phones
        'IP Phones' = [int]$item.ip_phones
        'Location' = $location
    }
}

Answer