Con javascript, dígame cómo obtener una matriz de resultados como la siguiente "resultList". Es similar a la instrucción UPDATE en SQL.
const dataList = [ { id: 1, xpstn: "10", ypstn: "11", value:{1,2,3,4}}, { id: 2, xpstn: "20", ypstn: "21", value:{1,2,3,4}}, { id: 3, xpstn: "30", ypstn: "31", value:{1,2,3,4}}, { id: 4, xpstn: "40", ypstn: "41", value:{1,2,3,4}}, ] const paramsList = [ { id: 3, xpstn: "33", ypstn: "32", desc: "param"}, { id: 4, xpstn: "44", ypstn: "42", desc: "param"}, { id: 5, xpstn: "55", ypstn: "53", desc: "param"}, { id: 6, xpstn: "66", ypstn: "62", desc: "param"}, ]; let resultList = [ { id: 3, xpstn: "33", ypstn: "11", value:{1,2,3,4}}, { id: 4, xpstn: "44", ypstn: "21", value:{1,2,3,4}}, ]; La condición es que la identificación sea la misma y xpstn debe actualizarse. /* ACTUALIZAR X SET X.xpstn = Y.xpstn DESDE dataList X INNER JOIN paramsList Y
ON X.id = Y.id */
Espero que esto funcione para usted.
const dataList = [ { id: 1, xpstn: "10", ypstn: "11", value: [1, 2, 3, 4] }, { id: 2, xpstn: "20", ypstn: "21", value: [1, 2, 3, 4] }, { id: 3, xpstn: "30", ypstn: "31", value: [1, 2, 3, 4] }, { id: 4, xpstn: "40", ypstn: "41", value: [1, 2, 3, 4] }, ] const paramsList = [ { id: 3, xpstn: "33", ypstn: "32", desc: "param" }, { id: 4, xpstn: "44", ypstn: "42", desc: "param" }, { id: 5, xpstn: "55", ypstn: "53", desc: "param" }, { id: 6, xpstn: "66", ypstn: "62", desc: "param" }, ]; let resultList = [ { id: 3, xpstn: "33", ypstn: "31", value: [1, 2, 3, 4] }, { id: 4, xpstn: "44", ypstn: "41", value: [1, 2, 3, 4] }, ]; /* UPDATE X SET X.xpstn = Y.xpstn FROM dataList X INNER JOIN paramsList Y ON X.id = Y.id */ const update = (data = [], params = []) => { resultList = []; data = data.forEach(d => { if (params.some(p => p.id === d.id)) { r = { ...d, xpstn: params.find(p => p.id === d.id).xpstn } resultList.push(r); } }); return resultList; } console.log("result", update(dataList, paramsList));Solución con reducir:
const dataList = [{ id: 1, xpstn: "10", ypstn: "11", value: [1, 2, 3, 4] },{ id: 2, xpstn: "20", ypstn: "21", value: [1, 2, 3, 4] },{ id: 3, xpstn: "30", ypstn: "31", value: [1, 2, 3, 4] },{ id: 4, xpstn: "40", ypstn: "41", value: [1, 2, 3, 4] }]; const paramsList = [{ id: 3, xpstn: "33", ypstn: "32", desc: "param" },{ id: 4, xpstn: "44", ypstn: "42", desc: "param" },{ id: 5, xpstn: "55", ypstn: "53", desc: "param" },{ id: 6, xpstn: "66", ypstn: "62", desc: "param" }]; const resultList = dataList.reduce((acc, dataItem) => { const paramItem = paramsList.find(({ id }) => id === dataItem.id); if (paramItem) { const { xpstn } = paramItem; acc.push({ ...dataItem, xpstn }); } return acc; }, []); console.log(resultList) .as-console-wrapper { max-height: 100% !important; top: 0 }