Yaml to csv - how to convert map object

[iGabyTM]

I have a yaml file that looks like this:

- name: Object 1
  map:
    simple: Hello
    deeper:
      value: World
- name: Object 2
  map:
    simple: Hello
    deeper:
      value: World

And I wand the csv to look like this:

name,map.simple,map.deeper.value
Object 1,Hello,World
Object 2,Hello,World

Curreny when I use yq -o=csv test.yaml it complains about !!map not supported. I just want to get the full path of a key as column name and then the value at that path.
The object is quite big and I can't really put all possible keys and their path in the command.

[mikefarah]

Tricky one:

yq -oc '.[] |= ( (.. | select(kind == "scalar")) as $i ireduce({}; . + { ($i | path | .[1:] | join(".")) : $i } )  )' data1.yaml
name,map.simple,map.deeper.value
Object 1,Hello,World
Object 2,Hello2,World2

Explanation:

• We need to create a simple array of key value pairs, where the key is the dot path of each scalar value in the original doc.
• We'll update each entry in the original array, wrt to itself .[] |= ....
• For each element, we will recursively .. match all the scalar values select(kind == "scalar") and reduce those into a new object
• The object will have the path as the key $i | path - but we want to exclude the array index .[1:] and join that together with dots join(".")
• The value will be the value itself $i

Hope that makes sense!