転置とJSON展開を組み合わせてデータを展開します。

インプットデータ（カラム名：all）

[
 {
  "name": "Alice Johnson",
  "age": 28,
  "address": {"street": "456 Elm St","city": "Springfield"}
 },
 {
  "name": "Bob Smith",
  "age": 52,
  "address": {"street": "789 Oak Ave","city": "Riverside"}
 },
 {
  "name": "Carol Williams",
  "age": 35,
  "address":{"street": "101 Pine Ln","city": "Hillcrest"}
 },
 {
  "name": "David Brown",
  "age": 61,
  "address":{"street": "222 Maple Dr","city": "Valleyview"}
 }
]

ワークフロー

設定内容

転置

JSON展開

アウトプットデータ