Re-organize json using jq

Question

I want to re-organize a json using jq. My json is like:

[
  {
    "id": "id1",
    "name": "Robin"
  },
  {
    "id": "id2",
    "name": "John"
  },
  {
    "id": "id3",
    "name": "Jane"
  }
]

I want to have an output as :

[
  {
    "Robin": "id1"
  },
  {
    "John": "id2"
  },
  {
    "Jane": "id3"
  }
]

How to achieve this?

Thanks in advance

Does this answer your question? [How to swap key and value of an object using jq?](https://stackoverflow.com/questions/40847936/how-to-swap-key-and-value-of-an-object-using-jq) — Benjamin W., Feb 24 '21 at 23:57

score 0 · Accepted Answer · answered Feb 25 '21 at 11:59

0

Yu need:

cat data1.jtxt | jq 'to_entries|map({(.value.name):(.value.id)})'

My output:

[
      {
        "Robin": "id1"
      },
      {
        "John": "id2"
      },
      {
        "Jane": "id3"
      }
    ]

answered Feb 25 '21 at 11:59

score 0 · Answer 2 · answered May 30 '22 at 13:07

I cannot understand how was this command so difficult to find

[.[] | {(.id):.name}] | add

gives you:

{
  "id1": "Robin",
  "id2": "John",
  "id3": "Jane"
}

If you want to keep the "object separation" just remove the | add

This question somehow led me to it.

2 Answers2