如何结合两个数组以使用Jolt创建键值对?

我已经创建了一个规范,可以将JSON转换为:

{
  "rows" : [ {
    "row" : [ "row1","row2","row3" ],"header" : [ "header1","header2","header3" ]
  },{
    "row" : [ "row4","row5","row6" ],"header3" ]
  } ]
}

我正在努力将其转换为键值对,我想要的输出将是:

{
"header1" : "row1","header2" : "row2","header3" : "row3","header4" : "row4","header5" : "row5","header6" : "row6"
}

使用Jolt可以做到吗?

likesirzzzz 回答:如何结合两个数组以使用Jolt创建键值对?

您的输入中是否存在复制/粘贴错误?从所需的输出来看,第二个对象的header数组应为["header4","header5","header6"]。如果是这样,此规范应该可以工作:

[
  {
    "operation": "shift","spec": {
      "rows": {
        "*": {
          "header": {
            "*": {
              "*": {
                "@(3,row[#2])": "&"
              }
            }
          }
        }
      }
    }
  }
]
本文链接:https://www.f2er.com/3090067.html

大家都在问