He estado tratando de conseguir este, pero todavía es difícil para mí.
Los datos:
let data = [ [1, "Item A", "Food", 10], [2, "Item B", "Food", 5], [3, "Item C", "Food", 30], [4, "Item A", "Hygiene", 30], [4, "Item A", "Hygiene", 50], [6, "Item D", "Food", 7], [3, "Item C", "Food", 8], [1, "Item A", "Food", 60], ]Resultado
let result = [ [1, "Item A", "Food", 70], [2, "Item B", "Food", 5], [3, "Item C", "Food", 38], [4, "Item A", "Hygiene", 80], [6, "Item D", "Food", 7], ] Esto es reduce() básico, que imagino que sería el camino a seguir, pero ¿cómo establecer los criterios y generar filas únicas?
const array1 = [1, 2, 3, 4]; const initialValue = 0; const sumWithInitial = array1.reduce( (previousValue, currentValue) => previousValue + currentValue, initialValue ); console.log(sumWithInitial);¡Aprecio tu ayuda!
He usado el map con findIndex
También utilicé los métodos reverse() , Object.values con Object.fromEntries para obtener los únicos:
let data = [ [1, "Item A", "Food", 10], [2, "Item B", "Food", 5], [3, "Item C", "Food", 30], [4, "Item A", "Hygiene", 30], [4, "Item A", "Hygiene", 50], [6, "Item D", "Food", 7], [3, "Item C", "Food", 8], [1, "Item A", "Food", 60], ] let objs = data.slice(); //in order to not mutate the source array data let sumObjs = objs.map((curr, i) => { let indexPrev = objs.findIndex( (item) => item[1] == curr[1] && item[2] == curr[2] ); if (indexPrev != -1 && i != indexPrev) { //i != indexPrev to not accumelate the current one //indexPrev =! -1 means that one is exist objs[indexPrev][3] += curr[3]; } return curr; }); let result = Object.values( Object.fromEntries( sumObjs.reverse().map((obj) => [JSON.stringify(obj[1]+obj[2]), obj]) ) ); console.log(result);Puede tomar una clave combinada para agrupar.
const data = [[1, "Item A", "Food", 10], [2, "Item B", "Food", 5], [3, "Item C", "Food", 30], [4, "Item A", "Hygiene", 30], [4, "Item A", "Hygiene", 50], [6, "Item D", "Food", 7], [3, "Item C", "Food", 8], [1, "Item A", "Food", 60]], result = Object.values(data.reduce((r, a) => { const key = [0, 1].map(i => a[i]).join('|'); if (r[key]) r[key][3] += a[3]; else r[key] = [...a]; return r; }, {})); console.log(result); .as-console-wrapper { max-height: 100% !important; top: 0; }