Jolt transform

Protector — Tue, 23 Nov 2021 15:33:58 GMT

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.

Re: Jolt transform

Protector — Wed, 24 Nov 2021 08:25:59 GMT

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"
}
}
]

question Re: Jolt transform in Support Questions

Jolt transform

Re: Jolt transform