Jolt, copy value along array

Question

I want to transform a JSON using JOLT, in the following way.:

Input of json file

{
  "Document_No": "ANG4",
  "LineNo10": {
    "Type": 1,
    "Customer_No_": "1"
  },
  "LineNo11": {
    "Type": 2,
    "Customer_No_": "2"
  },
  "LineNo12": {
    "Type": 3,
    "Customer_No_": "3"
  }
}

Desired output of json file

  [ 
    {
      "Document_No":"ANG4"  
      "Type" : 1,
      "Customer_No_" : "1",
      "Line_No" : "10"
    }, 
    {
      "Document_No":"ANG4"
      "Type" : 2,
      "Customer_No_" : "2",
      "Line_No" : "11"
    }, 
    {
      "Document_No":"ANG4"
      "Type" : 3,
      "Customer_No_" : "3",
      "Line_No" : "12"
    } 
    ]

I don't lack a lot, but i don't know what transformations add to get the desired output

my Jolt specificaton is below

[
  {
    "operation": "shift",
    "spec": {
      "LineNo*": {
        "@": "&",
        "$": "&.Line_No"
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "@": "[]"
      }
    }
  }
]

My output json file :

[ {
  "Type" : 1,
  "Customer_No_" : "1",
  "Line_No" : "LineNo10"
}, {
  "Type" : 2,
  "Customer_No_" : "2",
  "Line_No" : "LineNo11"
}, {
  "Type" : 3,
  "Customer_No_" : "3",
  "Line_No" : "LineNo12"
} ]

Could anyone help me with this?

score 0 · Answer 1 · answered Nov 04 '18 at 19:12

Spec

[
  {
    "operation": "shift",
    "spec": {
      "LineNo*": {
        // copy Document_No down into the "LineNo" maps
        "@(1,Document_No)": "&1.Document_No",
        "$": "&1.Line_No",
        "*": "&1.&"
      }
    }
  },
  {
    // accumulate all the "built" LineNo's into an array
    "operation": "shift",
    "spec": {
      "*": {
        "@": "[]"
      }
    }
  }
]

Jolt, copy value along array

1 Answers1