I need to use value of a field to lookup another value in map.
{
"name": "Smith",
"Occupation": {
"Smith": "Engineer",
"John": "Plumber",
"Mary": "Doctor"
}
}
output:
{
"Name": "Smith",
"Job": "Engineer"
}
how to do this using jolt?
I need to use value of a field to lookup another value in map.
{
"name": "Smith",
"Occupation": {
"Smith": "Engineer",
"John": "Plumber",
"Mary": "Doctor"
}
}
output:
{
"Name": "Smith",
"Job": "Engineer"
}
how to do this using jolt?
Share Improve this question edited Jan 17 at 16:16 Barbaros Özhan 65.4k11 gold badges36 silver badges61 bronze badges asked Jan 17 at 15:43 SunnydaysSunnydays 455 bronze badges1 Answer
Reset to default 2You can use such a single shift transformation :
[
{
"operation": "shift",
"spec": {
"name": {
"*": {
"@(2,Occupation.&)": "Job"
},
"@": "&"//replicates "name" itself
}
}
}
]
the demo on the site Jolt Transform Demo Using v0.1.1 is :