How to flatten JSON array values as CSV using JQ

Question

I have a JSON file containing application clients and their associated application features:

{
    "client-A": [
        "feature-x"
    ],
    "client-B": [
        "feature-x",
        "feature-y"
    ],
    "client-C": [
        "feature-z"
    ],
    "client-D": [
        "feature-x",
        "feature-z"
    ],
    ...
}

I'm trying to turn this into the following CSV:

client,feature
client-A,feature-x
client-B,feature-x
client-B,feature-y
client-C,feature-z
client-D,feature-x
client-D,feature-z

What's an easy way using jq to get this done?

beny23 · Accepted Answer · 2019-10-01 23:54:22Z

3

Not sure whether this is the most efficient way of doing it, but you can convert use the following pipeline:

<yourfile.json jq -r 'to_entries | .[] | { key: .key, value: .value[] } | [ .key, .value ] | @csv'

to_entries converts the structure into "key value" pairs, which can then be operated on. The { key: .key, value: .value[] } bit will convert the array into multiple rows...

answered Oct 1, 2019 at 23:54

beny23

35.1k6 gold badges84 silver badges86 bronze badges

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

1 Comment

peak Over a year ago

The following would be slightly more efficient: to_entries[] | [.key] + (.value[]|[.]) | @csv

Collectives™ on Stack Overflow

How to flatten JSON array values as CSV using JQ

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest