Not getting Expected output Using Jolt in NiFi

[#1]

Hi Team,

I am using Jolt for the input:

{
"headers": {
"query": "NA",
"param": "false"
},
"data": [
{
"SEQ_NUM": [
162,
162,
162,
162,
162,
162,
162,
162
]
},
{
"SEQ_NUM": [
162,
162,
162,
162,
162,
162,
162,
162
]
}
]
}

Jolt Spec:

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

Output:

[ {
"SEQ_NUM" : [ 162, 162 ]
}, {
"SEQ_NUM" : [ 162, 162 ]
}, {
"SEQ_NUM" : [ 162, 162 ]
}, {
"SEQ_NUM" : [ 162, 162 ]
}, {
"SEQ_NUM" : [ 162, 162 ]
}, {
"SEQ_NUM" : [ 162, 162 ]
}, {
"SEQ_NUM" : [ 162, 162 ]
}, {
"SEQ_NUM" : [ 162, 162 ]
} ]

Expected Output:

[ {
"SEQ_NUM" : 162
}, {
"SEQ_NUM" : 162
}, {
"SEQ_NUM" : 162
}, {
"SEQ_NUM" : 162
}, {
"SEQ_NUM" : 162
}, {
"SEQ_NUM" : 162
}, {
"SEQ_NUM" : 162
}, {
"SEQ_NUM" : 162
} ]

Can you please help me with the same.

Thank you

[#2 · Accepted solution]

Hello @Techie123,

can you tell a bit more about what you want to achive?

Do you want just use the first or second object of 'data'?

Then you have to change:

"data": {
"0": {

"data": {
"1": {

 Or how do you want to progress - can it that the numbers are not similiar?

We dont know how your results can be look like

Greetings