jq rename nested json key and place under same key

I want to rename nested json key and keep under same schema.

Input:

"properties":
 {
  "name": "Ram",
  "age": "17",
  "department": "Sony"
 }

Code : jq '[.["properties.company"] = .properties.department| del(.properties.department)]'  file

Output:

"properties":
 {
  "name": "Ram",
  "age": "17"  
 }
"properties.company" = "Sony"

Expected Output should be :

"properties":
 {
  "name": "Ram",
  "age": "17",
  "company": "Sony"  
 }

What I am doing wrong ?

>Solution :

You have several options, but for that you need to have a valid input JSON such as:

{
  "properties": {
    "name": "Ram",
    "age": "17",
    "department": "Sony"
  }
}

With del

This assigns the new property first, then deletes the old one.

.properties | .company = .department | del(.department)

Constructing a new object with {}

This is building a new object from scratch, copying all existing properties and renaming as needed.

.properties |= { name, age, company: .department }

Merging objects

This is a combination of the first two approaches. The property is deleted, while it is being renamed in the new object. Both objects are ultimately merged to form the result.

.properties |=  del(.department) + { company: .department }

Changing key name with with_entries

This iterates over all key-value pairs and (re-)assigns the key name.

.properties |= with_entries(.key |= if . == "department" then "company" else . end)

or if you dislike ifs: same as above, but uses select(cond) // alternative to select an alternative value unless the condition is met.

.properties |= with_entries(.key |= (select(. != "department") // "company"))