Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Jolt Specification, Apache Nifi

Solved Go to solution

Jolt Specification, Apache Nifi

New Contributor
I have the following input format
INPUT.JSON
 

 

[
    {
        "name": "adam",
        "age": 12,
        "address": {
            "city": "delhi",
            "country": "india",
            "zip": "110011"
        }
    },
    {
        "name": "louis",
        "age": 23,
        "address": {
            "city": "goa",
            "country": "india",
            "zip": "110022"
        }
    }
]

 

 

After applying jolt transformation i want to get the following output

DESIRED OUTPUT.JSON

 

 

[
    {
        "name": "adam",
        "age": 12,
        "address": {
            "current_city": "delhi",            //change here
            "current_country": "india",         //change here
            "zipode": "110011"                  //change here
        }
    },

    {
        "name": "louis",
        "age": 23,
        "address": {
            "current_city": "goa",              //change here
            "current_country": "india",         //change here
            "zipode": "110022"                  //change here
        }
    }
]

 

 

 

Can you please help me with the jolt spec. thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Jolt Specification, Apache Nifi

Contributor

@shivam-optimus 

[
{
"operation": "shift",
"spec": {
"*": {
"address": {
"city": "[&2].address.current_city",
"country": "[&2].address.current_country",
"zip": "[&2].address.zipcode"
},
"*": "[&1].&"
}
}
}
]

 

View solution in original post

1 REPLY 1
Highlighted

Re: Jolt Specification, Apache Nifi

Contributor

@shivam-optimus 

[
{
"operation": "shift",
"spec": {
"*": {
"address": {
"city": "[&2].address.current_city",
"country": "[&2].address.current_country",
"zip": "[&2].address.zipcode"
},
"*": "[&1].&"
}
}
}
]

 

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here