Jolt transform

[#1]

Hello everyone! I need a help in Jolt transform.

I have array, that consist from many json objects. (https://jolt-demo.appspot.com/ )

[

  {
     "table_name": "table_vd",
     "scratch_name": "l1_sample_1_1",
     "scratch_order": 1
  },
  {
     "table_name": "table_vd",
     "scratch_name": "l1_sample_1_1",
     "scratch_order": 34
  },
  {
     "table_name": "table_vd",
     "scratch_name": "l1_sample_2",
     "scratch_order": 3
  }
]

What transformation of Jolt needs to be done to get the following result?

Now i have next Jolt construction.

[
  {
     "operation": "shift",
     "spec": {
        "*": {
           "table_name": "table_name",
           "*": { "@0": "data[0].&1" }
        }
     }
  }
]

But the result is not correct.

[#2 · Accepted solution]

This task has been successfully solved! The required Jolt construction is shown below.

[
  {

     "operation": "shift",
     "spec": {
       "*": {
         "table_name": "&",
         "*": "data[&1].&"
       }
     }
  },
  { 
     "operation": "cardinality",
     "spec": {
       "table_name": "ONE"
     }
  }
]