I would like to “normalize” a JSON array of items with the help of jolt.

JSON input:

Source JSON:

Source JSON:

I’m working on a JOLT transformation where I need to merge two fields, AccountNumber and EntityID, retaining only the non-empty value. In my input, one of these fields will always have a value, but never both. Additionally, I want to keep other relevant attributes in the output.

I’m working on a JOLT transformation where I need to merge two fields, AccountNumber and EntityID, retaining only the non-empty value. In my input, one of these fields will always have a value, but never both. Additionally, I want to keep other relevant attributes in the output.

I have been trying to modify a Json using Jolt and no matter what operators I try, I am not able to solve the problem. I’m working on v0.1.1 and using Jolt Transform Demo.

Hi I’am trying a jolt transform of below

Hi I’am trying a jolt transform of below

Hi I’am trying a jolt transform of below