Map array to other array values in JQ

Question

How to map array to other array values in jq?

I have two JSON arrays.

[
  {
    "date": "2021/9/12",
    "rate": 7,
    "path": "f"
  },
  {
    "date": "2021/9/13",
    "rate": 8,
    "path": "f"
  },
  {
    "date": "2021/9/14",
    "rate": 8,
    "path": "f"
  },
]

[
  "562949953740755",
  "562949953740743",
  "562949953740744"
]

I want to have a result like this below.

[
  {
    "date": "2021/9/12",
    "rate": 7,
    "path": "f",
    "inode": "562949953740755"
  },
  {
    "date": "2021/9/13",
    "rate": 8,
    "path": "f",
    "inode": "562949953740743"
  },
  {
    "date": "2021/9/14",
    "rate": 8,
    "path": "f",
    "inode": "562949953740744"
  },
]

I tried: But I have no clue how to achieve this.

jq -s '.[1] as $file | .[0] | (.[].path) |= (range($file|length) as $i | $file[$i]) ' <(cat a.json) <(cat b.json)

oguz ismail · Accepted Answer · 2021-09-16 17:12:04Z

3

Don't reinvent the transpose wheel.

jq -s 'transpose | map(.[0] + {inode: .[1]})' a.json b.json

^{Online demo}

answered Sep 16, 2021 at 17:12

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

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

Comments

Inian · Accepted Answer · 2021-09-17 08:12:07Z

1

Use the array file (inode) as reference and slurp its content ahead of processing the original file.

jq --slurpfile inode b.json '
  reduce range(0, ($inode[0]|length)) as $d (.; .[$d] += {inode: $inode[0][$d]})' a.json

Note that, this works as long as there are equal number of elements in both your JSON arrays.

Another attempt without involving any "slurps" of the input file (probably faster than the earlier one)

jq -n 'input as $inode | input | 
  reduce range(0, length) as $d (.; .[$d] += {inode: $inode[$d]})' b.json a.json

edited Sep 17, 2021 at 8:12

answered Sep 16, 2021 at 16:17

Inian

87k15 gold badges166 silver badges183 bronze badges

Collectives™ on Stack Overflow

Map array to other array values in JQ

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related