JS如何按paidOn字段分组合并数组 以workstreamName为键映射amount值
JavaScript数组结构按字段分组合并解决方案
实现思路
- 首先用
Map作为临时分组容器,以paidOn的值作为分组键,存储对应分组的结果对象 - 遍历原数组的每一项:
- 若当前
paidOn未在分组容器中存在,先初始化一个带paidOn属性的对象存入容器 - 将当前项的
workstreamName作为属性名、amount作为属性值,追加到对应分组的对象中
- 若当前
- 最后提取分组容器中所有的对象值,即可得到目标结构数组
完整实现代码
const data = [ { paidOn: "01", workstreamName: "Leeann", amount: 242759 }, { paidOn: "02", workstreamName: "Angelico", amount: 58142 }, { paidOn: "03", workstreamName: "Zorine", amount: 419310 }, { paidOn: "04", workstreamName: "Janine", amount: 135015 }, { paidOn: "05", workstreamName: "Shannon", amount: 6396 }, { paidOn: "05", workstreamName: "Wang", amount: 198277 }, { paidOn: "06", workstreamName: "Maurise", amount: 389081 }, { paidOn: "07", workstreamName: "Nike", amount: 125030 }, { paidOn: "08", workstreamName: "Teodor", amount: 142803 }, { paidOn: "08", workstreamName: "Stefan", amount: 398831 }, { paidOn: "09", workstreamName: "Fancy", amount: 353254 }, { paidOn: "10", workstreamName: "Salli", amount: 492496 }, { paidOn: "10", workstreamName: "Daniela", amount: 147206 }, { paidOn: "11", workstreamName: "Tandy", amount: 362225 }, { paidOn: "11", workstreamName: "Sidnee", amount: 381233 }, { paidOn: "11", workstreamName: "Kordula", amount: 86582 }, { paidOn: "12", workstreamName: "Dedra", amount: 443826 }, { paidOn: "02", workstreamName: "Essy", amount: 449565 }, ]; // 临时分组容器 const groupMap = new Map(); data.forEach(item => { const { paidOn, workstreamName, amount } = item; // 不存在该分组则初始化 if (!groupMap.has(paidOn)) { groupMap.set(paidOn, { paidOn }); } // 追加键值对到对应分组 const group = groupMap.get(paidOn); group[workstreamName] = amount; }); // 转换为数组得到最终结果 const result = Array.from(groupMap.values()); console.log(result);
说明
你之前的实现是将所有项的workstreamName和amount统一映射到同一个对象,缺少按paidOn分组的逻辑,上述代码通过Map容器实现分组后再做键值对映射,就能得到你需要的结构。
如果同一个paidOn下存在相同workstreamName的项,默认后续项的amount会覆盖之前的取值;如果需要对同人名的金额做累加,可将赋值逻辑修改为group[workstreamName] = (group[workstreamName] || 0) + amount即可。
内容的提问来源于stack exchange,提问作者konstantforce
相关产品推荐
相关产品推荐

