Comparing ID numbers and adding them together before storing them in a new array

Question

Comparing ID numbers and adding them together before storing them in a new array

In order to consolidate numbers with the same sequence ID and store the total sum in a new array named 'final', follow the steps below:

INPUT =>

$scope.initial = [{seq:11, name:'ABC', number:20},
                  {seq:11, name:'ABC', number:50},
                  {seq:11, name:'ABC', number:80},
                  {seq:12, name:'DEF', number:30},
                  {seq:13, name:'JKL', number:10},
                  {seq:13, name:'JKL', number:15}];

OUTPUT =>

$scope.final = [{seq:11, name:'ABC', number:150},
                 {seq:12, name:'DEF', number:30},
                 {seq:13, name:'JKL', number:25}];

Appreciate your cooperation!

javascript arrays angularjs json

Answer 1

Answer №1

 $scope.newArr = [];
 var accumulator = {};

 for(const {index, title, value} of $scope.initialArray){

   if(index === accumulator.index && title === accumulator.title){
     accumulator.value += value;
   } else {
     $scope.newArr.push(accumulator = {index, title, value});
   }

 }

An efficient way to combine elements based on certain conditions is to use an accumulator. It helps keep track of the current resulting element being built. By checking if the current element matches the accumulator, the values can be aggregated accordingly or a new element can be added as the new accumulator.

Answer 2

 $scope.newArr = [];
 var accumulator = {};

 for(const {index, title, value} of $scope.initialArray){

   if(index === accumulator.index && title === accumulator.title){
     accumulator.value += value;
   } else {
     $scope.newArr.push(accumulator = {index, title, value});
   }

 }

An efficient way to combine elements based on certain conditions is to use an accumulator. It helps keep track of the current resulting element being built. By checking if the current element matches the accumulator, the values can be aggregated accordingly or a new element can be added as the new accumulator.

Answer 3

Answer №2

Iterate through the array and verify if the specified sequence exists, if not, then append it

var data = [{
    seq: 11,
    name: 'ABC',
    number: 20
  },
  {
    seq: 11,
    name: 'ABC',
    number: 50
  },
  {
    seq: 11,
    name: 'ABC',
    number: 80
  },
  {
    seq: 12,
    name: 'DEF',
    number: 30
  },
  {
    seq: 13,
    name: 'JKL',
    number: 10
  },
  {
    seq: 13,
    name: 'JKL',
    number: 15
  }
];
var groupedData = [];
data.forEach(function(entry) {
  if (!this[entry.seq]) {
    this[entry.seq] = {
      seq: entry.seq,
      name: entry.name,
      number: 0
    };
    groupedData.push(this[entry.seq]);
  }
  this[entry.seq].number = (+this[entry.seq].number + +entry.number);
}, Object.create(null));

console.log(groupedData);

Answer 4

Iterate through the array and verify if the specified sequence exists, if not, then append it

var data = [{
    seq: 11,
    name: 'ABC',
    number: 20
  },
  {
    seq: 11,
    name: 'ABC',
    number: 50
  },
  {
    seq: 11,
    name: 'ABC',
    number: 80
  },
  {
    seq: 12,
    name: 'DEF',
    number: 30
  },
  {
    seq: 13,
    name: 'JKL',
    number: 10
  },
  {
    seq: 13,
    name: 'JKL',
    number: 15
  }
];
var groupedData = [];
data.forEach(function(entry) {
  if (!this[entry.seq]) {
    this[entry.seq] = {
      seq: entry.seq,
      name: entry.name,
      number: 0
    };
    groupedData.push(this[entry.seq]);
  }
  this[entry.seq].number = (+this[entry.seq].number + +entry.number);
}, Object.create(null));

console.log(groupedData);

Answer 5

Answer №3

If you want to simplify your code, consider using the reduce method like this:

$scope.data = [
    {id:1, name:'John', age:25},
    {id:2, name:'Jane', age:30},
    {id:3, name:'Alice', age:35},
    {id:4, name:'Bob', age:40}
];

var reducedData = $scope.data.reduce(function(acc, curr){
    acc[curr.id] ? acc[curr.id].age += curr.age : acc[curr.id] = curr;
    return acc;
}, {});

$scope.result = Object.keys(reducedData).map(function(key){ return reducedData[key]; });

Answer 6

If you want to simplify your code, consider using the reduce method like this:

$scope.data = [
    {id:1, name:'John', age:25},
    {id:2, name:'Jane', age:30},
    {id:3, name:'Alice', age:35},
    {id:4, name:'Bob', age:40}
];

var reducedData = $scope.data.reduce(function(acc, curr){
    acc[curr.id] ? acc[curr.id].age += curr.age : acc[curr.id] = curr;
    return acc;
}, {});

$scope.result = Object.keys(reducedData).map(function(key){ return reducedData[key]; });

Comparing ID numbers and adding them together before storing them in a new array

Answer №1

Answer №2

Answer №3

Similar questions

Trouble with CSS and JS tabs not activating when clicked?

Decoding the information received from Socket.IO within the Flash client

I'm still searching for a proper solution on how to access JavaScript/jQuery functions within Colorbox

An easy way to divide an array into a table

Retrieving JSON database entries from MySQL using PHP

How can you write a parameterless function in Ramda using a point-free style?

Using Jquery to retrieve the window size and dynamically apply it to a div's CSS, adjusting it accordingly when the

A Step-by-Step Guide to Setting Up and Utilizing V-Calendar in Vue.js

What are some ways to ensure that text can adapt to the size of a

A JavaScript code snippet that stores the total number of bytes read from a CSV file in a variable

The system seems to be having trouble locating the password property, as it is returning a value of

Ajax failing to trigger upon submission

Navigating with Angular's router occurs before the guard is fully completed

Trouble resolving a timer interruption in JavaScript

import the JSONP file from the local directory and assign it to a variable on

Prevent Click Event in JQuery

Tips for triggering a method in the parent controller from a button inside a ui-grid enclosed within a custom directive

What is the process of converting exactPageList from any to any[] before assigning it to pagefield?

Adjust the size at the location of the cursor

Invoking a C++ dll in the renderer process of a Node.js application with Electron using node ffi