I have below tried to build the json by using the jolt spec by remove the id in the nested json array please help me to provide the expected out json below Transactions object grouping ID needs to be corrected…
Please help me in providing jolt spec or update the below tried jolt spec to get desired output json shown below I already posted the similar question but tried to solution but not able to remove the duplicate entry inside…
Please help me in providing jolt spec or update the below tried jolt spec to get expected output json shown below, i have added few default value as part of requirement and not able to remove the duplicate entry inside…
I'm trying convert JSON by NiFi JOLTTransformRecord processor to tree with nested array. But I am having some trouble with converting the flat JSON to Nested JSON. I have looked at examples and didn't get any closer as to what…
I am new to jolt transformation. what would be the jolt spec to transform my source json { "version": "123", "payload": { "details": { "payload_json": "{"FName":"rishi","LName":"dx","Id":"ABC123","aadharId":"XYZ22"}" } } } to target JSON { "firstName": "rishi", "lastName": "dx", "id": "ABC123", "officialIds":…
Please help me to provide JOLT spec for the below input JSON. tried multiple approach but still not working. there is an condition check on risk attribute if risk is "0" then risklevel low .if it is "1" then High…
The possible values for applicableOn field are already known but they are not limited to clothes and bags like given in this sample input. Also, there can be multiple elements in purchases array with the same applicableOn type and the…
I am given the below json and it needs to be concatenated based on condition if it not null { "id": "4583", "price": "149.99", "sale_price": "" } Can someone help me out here? expected output { "id": "4583", "price": "149.99…
please provide the jolt spec for the following JSON input : [ { "name": "Manu", "age": 26, "location": "New York", "risk": "0" }, { "name": "Manju", "age": 29, "location": "New York city", "risk": null } ] if risk is 0,…
I have a JSON from source and I am trying to write a JOLT to flatten this data and convert it in to records so that I can insert it in to a Table. I have already written a JOLT…