admin管理员组

文章数量:1321257

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?

  • json
  • transform
  • 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 badges
Add a comment  | 

1 Answer 1

Reset to default 2

You 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 :

本文标签： jsonUsing Jolt transform to use value of a key to locate another value in mapStack Overflow

版权声明：本文标题：json - Using Jolt transform to use value of a key to locate another value in map - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1742094628a2420471.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。