Austin,
This one works for your sample data but doesn't extend to more fields
unless you keep repeating the pattern in the spec:
[
{
"operation": "shift",
"spec": {
"@Place1": "TestArray[0].Place",
"@Holder1": "TestArray[0].Holder",
"@Place2": "TestArray[1].Place",
"@Holder2": "TestArray[1].Holder"
}
}
]
Basically I don't know of a way to get the "1" from "Place1" into a
index that can be used in the target.
Regards,
Matt
On Tue, Feb 13, 2018 at 5:32 PM, Austin Duncan <adun...@pyaanalytics.com> wrote:
> All, I am trying to transfrom a json. I want the final to look like:
> "TestArray": [{
> "Place": "Test1",
> "Holder": "Test2"
> },
> {
> "Place": "Test3",
> "Holder": "Test4"
> }
> My source Json is flat with these specs:
> "Place1" : "Test1",
> "Holder1" : "Test2",
> "Place2" : "Test3",
> "Holder2" : "Test4"
>
> With this transform:
>
> [
> {
> "operation": "shift",
> "spec": {
> "@Place1": "TestArray[].Place",
> "@Holder1": "TestArray[].Holder",
> "@Place2": "TestArray[].Place",
> "@Holder2": "TestArray[].Holder"
> }
> }
> ]
>
> I get the following result:
>
> {
> "TestArray" : [ {
> "Payer" : "Test1"
> }, {
> "PolicyNumber" : "Test2"
> }, {
> "Payer" : "Test3"
> }, {
> "PolicyNumber" : "Test4"
> } ]
> }
>
> Does anyone have any insight as to how to fix my problem? I am at a loss
> here and Am not quite sure where to go.
>
