Using JoltTransformJSON, you can inject the "key" and "theme" entries from p into the array, and create a top-level array from it. Try the following Shift spec: {
"operation": "shift",
"spec": {
"s": {
"*": {
"@(2,p)": {
"key": "[#3].key",
"theme": "[#3].theme"
},
"*": "[#2].&"
}
}
}
} Given your input, it produces the following output: [ {
"key" : "k1",
"theme" : "default",
"x" : 1,
"y" : "0.1"
}, {
"key" : "k1",
"theme" : "default",
"x" : 2,
"y" : "0.2"
} ] Now you can use a SplitJson (with a JSON Path of $) to get the individual records. If you want to keep them as JSON then you're done; if you want to convert it to CSV, you'd need EvaluateJsonPath like @Timothy Spann mentioned, then ReplaceText with Expression Language to set the fields, something like "${key}, ${theme}, ${x}, ${y}". An alternative to Jolt, which Tim alluded to, is to use EvaluateJsonPath to get the p.* fields into attributes, then SplitJson, then EvaluateJsonPath to get the s.* attributes, then ReplaceText (either generating JSON or CSV as described). In my opinion I'd use the Jolt transform and keep the content in JSON as long as possible, rather than generating attributes.
... View more
