You need to enable JavaScript to run this app. JS如何按paidOn字段分组合并数组 以workstreamName为键映射amount值
优惠活动
大模型
产品
解决方案
定价
更多

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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.09 06:21:03