How to use jq to transform array of objects into separated list of key values - Outputing specific key value instead of array index

Question

This is related to my previous question: How to use jq to format array of objects to separated list of key values

How can I (generically) transform the input file below to the output file below, using jq. The value at key "id" uniqely identifies the array element. The record format of the output file is: (value at key "id") | key | value.

I can do this if I add awk to solution of previous question, but I am having trouble getting my head around doing it all in jq.

Input file:

[{"id": 11, "b": 100},
 {"id": 12, "d": "fred", "e": 300}]

Output File:

11|id|11
11|b|100
12|id|12
12|d|fred
12|e|300

pmf · Accepted Answer · 2022-05-11 12:21:30Z

4

Here's a solution using to_entries, which decomposes an object into an array of key-value pairs:

jq -r '.[] | .id as $id | to_entries[] | [$id,.key,.value] | join("|")'

11|id|11
11|b|100
12|id|12
12|d|fred
12|e|300

edited May 11, 2022 at 12:21

answered May 11, 2022 at 12:20

pmf

38.3k3 gold badges31 silver badges41 bronze badges

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

2 Comments

Andreas Louv Over a year ago

This is the exact same thing that I came up with.

inky Over a year ago

This is a nice solution that has helped me learn jq

Collectives™ on Stack Overflow

How to use jq to transform array of objects into separated list of key values - Outputing specific key value instead of array index

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related