如何通过Jolt转换移除值缺失的对应键？

To eliminate entries where the corresponding input value is missing, use this two-step Jolt transformation:

Corrected Jolt Spec #

[
  {
    "operation": "shift",
    "spec": {
      "alldetails": {
        "classid": "Id_class",
        "teacherid": "Id_teacher",
        "schoolid": "Id_school"
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "$": "data[].source",
        "@": "data[#2].value"
      }
    }
  }
]

How It Works #

1. First Shift Operation: Maps input fields to their corresponding source names (e.g., classid → Id_class). Missing fields like teacherid are automatically excluded from this intermediate result.
2. Second Shift Operation: Converts each key-value pair from the intermediate object into entries in the data array:
   • $ references the current key to set the source field
   • @ references the current value to set the value field
   • #2 ensures value is added to the same array entry as its matching source

Result Output #

{
  "data": [
    {
      "source": "Id_class",
      "value": 1
    },
    {
      "source": "Id_school",
      "value": 3
    }
  ]
}

Content of the question is from Stack Exchange, asked by Vishavjeet