我尝试过在Linux cmd行上使用jq将json转换为csv，但没有成功。如有任何指导帮助，将不胜感激。

{
    "dir/file1.txt": [
      {
        "Setting": {
          "SettingA": "",
          "SettingB": null
        },
        "Rule": "Rulechecker.Rule15",
        "Description": "",
        "Line": 11,
        "Link": "www.sample.com",
        "Message": "Some message",
        "Severity": "error",
        "Span": [
          1,
          3
        ],
        "Match": "[id"
      },
      {
        "Setting": {
          "SettingA": "",
          "SettingB": null
        },
        "Check": "Rulechecker.Rule16",
        "Description": "",
        "Line": 27,
        "Link": "www.sample.com",
        "Message": "Fix the rule",
        "Severity": "error",
        "Span": [
          1,
          3
        ],
        "Match": "[id"
      }
    ],
    "dir/file2.txt": [
      {
        "Setting": {
          "SettingA": "",
          "SettingB": null
        },
        "Rule": "Rulechecker.Rule17",
        "Description": "",
        "Line": 51,
        "Link": "www.example.com",
        "Message": "Fix anoher 'rule'?",
        "Severity": "error",
        "Span": [
          1,
          18
        ],
        "Match": "[source,terminal]\n----\n"
      }
    ]
}

最后，我希望将dir/file1.txt、dir/file2.txt作为行显示在矩阵的左侧，将所有键作为列标题显示，并显示相应的值。

| Filename  | SettingA | SettingB | Rule | More columns... |
| -------- | -------------- | -------------- | -------------- | -------------- |
| dir/file1.txt    |             | null | Rulechecker.Rule15 | |
| dir/file1.txt   |             | null | Rulechecker.Rule16 | |
| dir/file2.txt   |             | null | Rulechecker.Rule17  | |