jq merge array of keys with array of values

Question

I have a json fragment with an array of keys and a separate array of values. Key 1 should match up to Value 1, etc. I'm trying to reformat with jq but not having much luck.

Original JSON:

{
  "result": {
    "event.KeyValues{}.Key": [
      "name",
      "gender",
      "employee",
      "email"
    ],
    "event.KeyValues{}.Value": [
      "tyler",
      "male",
      "yes",
      "[email protected]"
    ],
    "foo": "1",
    "bar": "2"
  }
}

Desired Output:

{
    "name": "tyler",
    "gender": "male",
    "employee": "yes",
    "email": "[email protected]"
}

oguz ismail · Accepted Answer · 2020-04-24 18:35:58Z

2

Use transpose to pair keys and values. Then you can make an object out of each pair and add them together to get the desired structure.

.result
| [."event.KeyValues{}.Key", ."event.KeyValues{}.Value"]
| transpose
| map({(.[0]): .[1]})
| add

^{Online demo}

answered Apr 24, 2020 at 18:35

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

jq merge array of keys with array of values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related