将元素数组转换为具有ids的对象的Jolt规范

Question

Jolt对我来说是新的，我一直在与这个问题作斗争，直到我创建这篇文章。

我想把这个：

{
    "Properties": [{
        "Id": "property1",
        "Values": ["randomValue1", "randomValue2"]
    }, {
        "Id": "property2",
        "Values": "randomValue3"
    }, {
        "Id": "property3",
        "Values": "randomValue4"
    }]
}

进入这个

{
    "Properties": [{
        "Id": "property1",
        "Values": "randomValue1"
    },{
        "Id": "property1",
        "Values": "randomValue2"
    }, {
        "Id": "property2",
        "Values": "randomValue3"
    }, {
        "Id": "property3",
        "Values": "randomValue4"
    }]
}

每个属性的值可以是1值，也可以是未知数量值的数组。

我将以下json更改为第一个json中的内容：

{
    "Properties": {
        "property1": ["randomValue1", "randomValue1"],
        "property2": ["randomValue3"],
        "property3": ["randomValue4"]
    }
}

[{
    "operation": "shift",
    "spec": {
        "Properties": {
            "*": {
                "*": "Properties[#2].Values",
                "$": "Properties[#2].Id"
            }
        }
    }
}]

RHS上的属性名称是通用的，属性值的数量也可能不同。提前感谢您抽出时间来帮助我。

Answer 1

检查这是否有帮助：

[
  {
    "operation": "cardinality",
    "spec": {
      "Properties": {
        "*": {
          // normalize values to always be a list
          "Values": "MANY"
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "Properties": {
        "*": {
          "Values": {
            "*": {
              // create arrays with values and ids
              "@": "Values",
              "@(2,Id)": "Id"
            }
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "Values": {
        "*": {
          // create the final list joining ids and values at the indexes you want
          "@": "Properties[&1].Values",
          "@(2,Id[#1])": "Properties[&1].Id"
        }
      }
    }
  }
]