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];
Measure-Object [-Average] [-Maximum] [-Minimum] [-Sum]出力
[
{
"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"
}
]