基于不同行数数据创建嵌套Jolt转换规则

需求说明：将JSON数据转换为嵌套结构，以practice_loc、prac_num、topId的组合作为分组嵌套依据：

• 当多条数据的这三个字段值（需统一数据类型，如数字与字符串形式的同一值视为相同）相同时，将每条数据独有的S1、S2、Result、Additional Info字段内容合并到subList数组中
• 单条数据也需保留practice_loc、prac_num、topId字段，并将剩余字段内容放入subList数组内

原始数据 #

[
  {
    "practice_loc": 120,
    "prac_num": "oswal",
    "topId": "t1",
    "S1": "A1",
    "Result": "fail",
    "Additional Info": "S1 not matched."
  },
  {
    "practice_loc": "120",
    "prac_num": "oswal",
    "topId": "t1",
    "S1": "A2",
    "S2": "B1",
    "Result": "pass"
  },
  {
    "practice_loc": "334",
    "prac_num": "L3",
    "topId": "plumcherry",
    "S1": "A3",
    "S2": "A1",
    "Result": "fail",
    "Additional Info": "S2 not matched."
  },
  {
    "practice_loc": "987",
    "prac_num": "L3",
    "topId": "artica",
    "Result": "pass"
  }
]

预期合并结果 #

[
  {
    "practice_loc": "120",
    "prac_num": "oswal",
    "topId": "t1",
    "subList": [
      {
        "S1": "A1",
        "Result": "fail",
        "Additional Info": "S1 not matched."
      },
      {
        "S1": "A2",
        "S2": "B1",
        "Result": "pass"
      }
    ]
  },
  {
    "practice_loc": "334",
    "prac_num": "L3",
    "topId": "plumcherry",
    "subList": [
      {
        "S1": "A3",
        "S2": "A1",
        "Result": "fail",
        "Additional Info": "S2 not matched."
      }
    ]
  },
  {
    "practice_loc": "987",
    "prac_num": "L3",
    "topId": "artica",
    "subList": [
      {
        "Result": "pass"
      }
    ]
  }
]

内容的提问来源于stack exchange，提问作者dracile