'm trying to modify big JSON file with more than 10K records. I have this kind of input and I need to make jolt transformation for each record : [
{
"id": 1031435,
"event_id": "Formula_257",
"formula_id": 257,
"ts_start": 1583164200084000,
"ts_end": 1583164484960000,
"type": "formula",
"details": {
"6aa0734f-6d6a-4b95-8a2b-2dde346f9df7": {
"PowerActiveTriPhase": 183836912
}
},
"ack_ts": null,
"ack_user": null
},
{
"id": 1031435,
"event_id": "Formula_257",
"formula_id": 257,
"ts_start": 1583164200084000,
"ts_end": 1583164484960000,
"type": "formula",
"details": {
"6aa0734f-6d6a-4b95-8a2b-2dde346f9df7": {
"PowerActiveTriPhase": 183836912
}
},
"ack_ts": null,
"ack_user": null
}
] This is my spec: [ { "operation": "shift", "spec": { "id": "id", "event_id": "event_id", "formula_id": "formula_id", "ts_start": "ts_start", "ts_end": "ts_end", "type": "type", "details": { "": { "$": "equipment_id", "": { "$": "parameter", "@": "value" } } }, "ack_ts": "ack_ts", "ack_user": "ack_user" } } ] It works for one record but doesn't work for >1 record and im getting null in output. How to fix it? @Shu_ashu @mburgess Thanks!
... View more
