Can i covert this in a CSV format where all the element gonna be under one row, without repeating the doc attribute?

Question

[ { "doc": "ghgagsa", "element": [ { "firstName": "John", "lastName": "Doe" }, { "firstName": "Anna", "lastName": "Smith" }, { "firstName": "Peter", "lastName": "Jones" } ] }, { "doc": "ghgagsaaa", "element": [ { "firstName": "Joaahn", "lastName": "Doae" }, { "firstName": "Anana", "lastName": "Smiath" }, { "firstName": "Petaaer", "lastName": "Jonaes" } ] } ]

Answer 1

Using jq, it's .[].element[]|[.firstName,.lastName]|@csv

Here an example https://jqplay.org/s/XmlRS6Yh9v