rproenca/gist:bfa316618823ff01c39a5643f90637a7

Created November 6, 2020 17:09

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rproenca/bfa316618823ff01c39a5643f90637a7.js"></script>
Save rproenca/bfa316618823ff01c39a5643f90637a7 to your computer and use it in GitHub Desktop.

Download ZIP

Transform an arbitrary JSON array into CSV

Raw

gistfile1.txt

cat input.json | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv' > output.csv

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment