从具有不同值数组的单个键数组转换键值对
从具有不同值数组的单个键数组转换键值对
提问于 2019-04-15 04:22:43
我需要转换json的键值对，以便在ejs表迭代中使用。
我将键值对转换为每个键值，将其转换为不可迭代的对象。
这里data.metaData是键，data.rows是要映射的值。
var data = {
metaData: [{
name: "SCHEDULED_TIME"
},
{
name: "TRIGGER_TIME"
},
{
name: "START_TIME"
},
{
name: "END_TIME"
},
{
name: "CEC_ID"
},
{
name: "TRIGGER_TYPE"
},
{
name: "STATUS"
},
{
name: "JOB_NAME"
},
],
rows: [
[
"12:20",
null,
null,
null,
null,
null,
null,
"CLARITY_ETL",
],
[
"15:50",
null,
null,
null,
null,
null,
null,
"CLARITY_ETL",
],
[
"18:30",
null,
null,
null,
null,
null,
null,
"BUDGET_ETL",
],
]
}
**
Expected result as: **
data = [{
"SCHEDULED_TIME": "12:20",
"TRIGGER_TIME": null,
"START_TIME": null,
"END_TIME": null,
"CEC_ID": null,
"TRIGGER_TYPE": null,
"STATUS": null,
"JOB_NAME": "CLARITY_ETL",
}, {
"SCHEDULED_TIME": "15:50",
"TRIGGER_TIME": null,
"START_TIME": null,
"END_TIME": null,
"CEC_ID": null,
"TRIGGER_TYPE": null,
"STATUS": null,
"JOB_NAME": "CLARITY_ETL",
}, {
"SCHEDULED_TIME": "18:30",
"TRIGGER_TIME": null,
"START_TIME": null,
"END_TIME": null,
"CEC_ID": null,
"TRIGGER_TYPE": null,
"STATUS": null,
"JOB_NAME": "BUDGET_ETL",
}]回答 1
Stack Overflow用户
发布于 2019-04-15 04:32:32
一种可能的解决方案是在rows上使用Array.map()，将每个row映射到一个object，生成的object的keys将来自metaData
var data = {
metaData: [
{name: "SCHEDULED_TIME"},
{name: "TRIGGER_TIME"},
{name: "START_TIME"},
{name: "END_TIME"},
{name: "CEC_ID"},
{name: "TRIGGER_TYPE"},
{name: "STATUS"},
{name: "JOB_NAME"}
],
rows: [
["12:20", null, null, null, null, null, null, "CLARITY_ETL"],
["15:50", null, null, null, null, null, null, "CLARITY_ETL"],
["18:30", null, null, null, null, null, null, "BUDGET_ETL"]
]
};
let res = data.rows.map((row) =>
{
let obj = {};
row.forEach((val, idx) => obj[data.metaData[idx].name] = val);
return obj;
});
console.log(res);.as-console {background-color:black !important; color:lime;}
.as-console-wrapper {max-height:100% !important; top:0;}
或者，如果您也使用Array.reduce()，则使用简化版本。
var data = {
metaData: [
{name: "SCHEDULED_TIME"},
{name: "TRIGGER_TIME"},
{name: "START_TIME"},
{name: "END_TIME"},
{name: "CEC_ID"},
{name: "TRIGGER_TYPE"},
{name: "STATUS"},
{name: "JOB_NAME"}
],
rows: [
["12:20", null, null, null, null, null, null, "CLARITY_ETL"],
["15:50", null, null, null, null, null, null, "CLARITY_ETL"],
["18:30", null, null, null, null, null, null, "BUDGET_ETL"]
]
};
let res = data.rows.map(
row => row.reduce((o, v, i) => ({...o, [data.metaData[i].name]: v}), {})
);
console.log(res);.as-console {background-color:black !important; color:lime;}
.as-console-wrapper {max-height:100% !important; top:0;}
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/55679699
复制相关文章
相似问题