jq: Forming CSV by selectively choosing values from object/embedded array

Question

Input is:

{"1.2.3.4":[{"Value":"myval1","Key":"mykey1"},   {"Value":"myval3","Key":"mykey3"},{"Value":"myval2","Key":"mykey2"},{"Value":"myval4","Key":"mykey4"}]}
{"4.5.6.7":[{"Value":"myval1","Key":"mykey1"},   {"Value":"myval3","Key":"mykey3"},{"Value":"myval2","Key":"mykey2"},{"Value":"myval4","Key":"mykey4"}]}

What I would like to get is:

"1.2.3.4,myval1,myval3"
"4.5.6.7,myval1,myval3"

Basically extract the first field, and then values of "mykey1" and "mykey2" from the embedded value field.

Edit:

What I have tried:

I could extract the values by doing something like below:

jq -c '."1.2.3.4" | .[]' | jq -s 'from_entries | [.mykey1, .mykey2] | join(",")'

I would like to include my object name and as well my object name varies, so I can't really filter by hard coded value

what you have tried?

Abhay Dixit
– Abhay Dixit

2016-09-21 15:31:16 +00:00
Commented Sep 21, 2016 at 15:31 — Abhay Dixit
– Abhay Dixit, Commented Sep 21, 2016 at 15:31

Jeff Mercado · Accepted Answer · 2016-09-21 16:30:20Z

2

You could do this:

$ jq -r --argjson cols '["mykey1","mykey2"]' '[to_entries[] | .key, (.value | from_entries[$cols[]])] | @csv' input.json

Converting an object to a list of entries is an easy way to access both the keys and values in the object for your filter.

answered Sep 21, 2016 at 16:30

Jeff Mercado

136k34 gold badges268 silver badges282 bronze badges

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

1 Comment

peak Over a year ago

If you really want "1.2.3.4,myval1,myval3" instead of "1.2.3.4","myval1","myval3", then use [join(",")] | @csv instead of just @csv

jq170727 · Accepted Answer · 2017-08-28 05:52:19Z

0

Here is another solution which generalizes Surki's approach:

  keys[] as $k
| .[$k]
| from_entries
| [$k, .mykey1, .mykey2]
| join(",")

answered Aug 28, 2017 at 5:52

jq170727

15.1k6 gold badges52 silver badges61 bronze badges

Collectives™ on Stack Overflow

jq: Forming CSV by selectively choosing values from object/embedded array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related