JSON配列 集計 Measure-Object

JSON配列 集計

PowerShell

$ERROR.Clear();

$records='';

$records=ConvertFrom-Json '[{"A":"500","B":"600","C":"700"},{"A":"1000","B":"2000","C":"3000"}]';

$records|Measure-Object -Property * -Sum|ConvertTo-Json;

$ERROR[0];

出力

[

{

"Count": 2,

"Average": null,

"Sum": 1500,

"Maximum": null,

"Minimum": null,

"Property": "A"

},

{

"Count": 2,

"Average": null,

"Sum": 2600,

"Maximum": null,

"Minimum": null,

"Property": "B"

},

{

"Count": 2,

"Average": null,

"Sum": 3700,

"Maximum": null,

"Minimum": null,

"Property": "C"

}

]