Group json
Group json
JavaScript
var outJSON = [{
"name": "First",
"Custnumber": "123SC"
},
{
"name": "Second",
"Custnumber": "67BC"
},
{
"name": "Third",
"Custnumber": "99ABC"
},
{
"name": "Fourth",
"Custnumber": "123SC"
}]
var output = '';
var groupBy = function (xs, key) {
return xs.reduce(function (rv, x) {
(rv[x[key]] = rv[x[key]] || []).push(x);
return rv;
}, {});
};
var groubedByTeam = groupBy(outJSON, 'Custnumber')
output = output + JSON.stringify( groubedByTeam, null, 2 ) + '<br/><br/>';
//JSON.stringify(groubedByTeam) + '<br/>';
Object.keys(groubedByTeam).forEach(function (category) {
output = output + `Custnumber ${category} has ${groubedByTeam[category].length} customers : <br/>`;
groubedByTeam[category].forEach(function (memb, i) {
output = output + `---->${i + 1}. ${memb.name}. <br/>`;
})
});
$("#m").html(output);