颠簸变换-将平面映射到层次（嵌套

Question

我正在尝试使用Jolt将平面结构映射到层次结构http://jolt-demo.appspot.com/#andrewkcarter2:

我的输入是一个包含客户详细信息的平面结构：下面是我的JSON输入：

[
  {
    "customerId": "100",
    "customerName": "Ken",
    "accountId": "1001",
    "accountType": "SAV",
    "transactionAmount": "100.00",
    "homeaddress": "800 W Trade St",
    "businessaddress": "440 S Church St"
  },
  {
    "customerId": "100",
    "customerName": "Ken",
    "accountId": "1001",
    "accountType": "SAV",
    "transactionAmount": "15.00",
    "homeaddress": "800 W Trade St",
    "businessaddress": "440 S Church St"
  },
  {
    "customerId": "100",
    "customerName": "Ken",
    "accountId": "1002",
    "accountType": "CHK",
    "transactionAmount": "200.00",
    "homeaddress": "900 E 4th St",
    "businessaddress": "500 N Church St"
  },
  {
    "customerId": "100",
    "customerName": "Ken",
    "accountId": "1002",
    "accountType": "CHK",
    "transactionAmount": "116.00",
    "homeaddress": "900 E th St",
    "businessaddress": "500 N Church St"
  }
]

这是我的 JOLT 规格：

[
  {
    "operation": "shift",
    "spec": {
    "*": {
    "customerId": {
      "*": {
        "@2": "temp.&1[]"
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
    "temp": {
    "*": {
      "0": {
        "customerId": "[#3].customerId",
        "customerName": "[#3].customerName",
        "accountId": "[#3].accounts[0].accountId",
        "accountType": "[#3].accounts[0].accountType",
        "transactionAmount": " 
         [#3].accounts[0].transactions[0].transactionAmount",
        "homeaddress": "[#3].addresses[0].homeaddress",
        "businessaddress": "[#3].addresses[0].businessaddres"
      },
      "*": {
        "accountId": "[#3].accounts[&1].accountId",
        "accountType": "[#3].accounts[&1].accountType",
        "transactionAmount": "[#3].accounts[&1].transactions[&1].&",
        "homeaddress": "[#3].addresses[&1].homeaddress",
        "businessaddress": "[#3].addresses[&1].businessaddress"
       }
      }
    }
   }
 }
]

我得到的结果是：

[ {
  "customerId" : "100",
  "customerName" : "Ken",
  "accounts" : [ {
      "accountId" : "1001",
      "accountType" : "SAV",
      "transactions" : [ {
      "transactionAmount" : "100.00"
    } ]
  }, {
      "accountId" : "1001",
      "accountType" : "SAV",
      "transactions" : [ null, {
      "transactionAmount" : "15.00"
    } ]
  }, {
      "accountId" : "1002",
      "accountType" : "CHK",
      "transactions" : [ null, null, {
      "transactionAmount" : "200.00"
    } ]
   }, {
      "accountId" : "1002",
      "accountType" : "CHK",
      "transactions" : [ null, null, null, {
      "transactionAmount" : "116.00"
      } ]
  } ],
  "addresses" : [ {
     "homeaddress" : "800 W Trade St",
     "businessaddres" : "440 S Church St"
    }, {
     "homeaddress" : "800 W Trade St",
     "businessaddress" : "440 S Church St"
    }, {
     "homeaddress" : "900 E 4th St",
     "businessaddress" : "500 N Church St"
    }, {
     "homeaddress" : "900 E th St",
     "businessaddress" : "500 N Church St"
  } ]
} ]

在上面的输出中，我们看到帐户1001和1002重复交易的次数。我不希望这种情况发生，我希望交易被归类在各自的账户下。

所以，我想要的输出应该是：

[ {
  "customerId" : "100",
  "customerName" : "Ken",
  "accounts" : [ {
    "accountId" : "1001",
    "accountType" : "SAV",
        "transactions" : [ {
              "transactionAmount" : "100.00"
           },
           {
              "transactionAmount" : "15.00"
        } ]
      }, {
    "accountId" : "1002",
    "accountType" : "CHK",
    "transactions" : [ null, null, {
               "transactionAmount" : "200.00"
               },{
              "transactionAmount" : "116.00"
        } ]
      },
     "addresses" : [ {
    "homeaddress" : "800 W Trade St",
    "businessaddres" : "440 S Church St"
  }, {
    "homeaddress" : "900 E th St",
    "businessaddress" : "500 N Church St"
  } ]
} ]

类似的唯一地址只应该出现在结果中。

是否有办法将交易分组到各自的账户下。有人能帮忙吗？

Answer 1

https://github.com/bazaarvoice/jolt/issues/575回答到这里

请注意，这是一项复杂的任务。对两个不同的输入值进行透视，然后通过管道将数据透视到多个数组中。

这是可能的，但很乱，可能很脆。老实说，我不推荐它。