Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Jolt transform

avatar
Explorer

Hello everyone! I need a help in Jolt transform.

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

 

[

  {
     "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?

4.png

 

Now i have next Jolt construction.

2.png

 

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

 

 

But the result is not correct.

3.png

 

1 ACCEPTED SOLUTION

avatar
Explorer
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
Explorer
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login