Support Questions

Find answers, ask questions, and share your expertise

functions =min(),=max(),=intsum() not giving expected result.

avatar
Explorer

HI 

while using the JoltTransformJSON , found some limitation of methods like (=min(),=max(),=intsum()). Not getting the expected result. Please add suggestions if we have a solution for this issue. thanks.

Json Input=========================================

{
"NUMBER": {
"array1": [
9223372036854775807
],
"array2": [
4294967295
],
"array3": [
2147483646
]
}
}

 

 

Jolt Spec===========================

[
{
"operation": "modify-overwrite-beta",
"spec": {
"NUMBER": {
"sumArray1": "=intSum(@(1,array1))",
"maxArray1": "=max(@(1,array1))",
"minArray1": "=min(@(1,array1))",
"sumArray2": "=intSum(@(1,array2))",
"maxArray2": "=max(@(1,array2))",
"minArray2": "=min(@(1,array2))",
"sumArray3": "=intSum(@(1,array3))",
"maxArray3": "=max(@(1,array3))",
"minArray3": "=min(@(1,array3))"
}
}
}
]

 


{
"NUMBER": {
"array1": [9223372036854775807],
"array2": [4294967295],
"array3": [2147483646],
"sumArray1": -1,
"maxArray1": 9223372036854775807,
"minArray1": 2147483647,
"sumArray2": -1,
"maxArray2": 4294967295,
"minArray2": 2147483647,
"sumArray3": 2147483646,
"maxArray3": 2147483646,
"minArray3": 2147483646
}
}



0 REPLIES 0