DSQLマップでループを分割
複数のループを1つのループにマッピングします。
始める前に
このタスクについて
{
"bicycles": [
{
"make": "MBIKE",
"description": "27.5 inch electric mountain bike",
"color": "blue",
"price": 899.99
},
{
"make": "EBIKE",
"description": "Electric hybrid bike",
"color": "grey/green",
"price": 999.99
},
{
"make": "WBIKE",
"description": "Women's road bike",
"color": "white",
"price": 299.99
}
],
"scooters": [
{
"make": "ESCOOT",
"description": "Camou electric scooter",
"color": "black",
"price": 749
},
{
"make": "EVSCOOT",
"description": "Folding electric velocity+ scooter",
"color": "black",
"price": 599.99
},
{
"make": "KSCOOT",
"description": "24 volt kid scooter",
"color": "white",
"price": 299.99
}
]
}{
"items": [
{
"make": "",
"description": "",
"price": ""
}
]
}手順
-
-
bicycles入力エレメントを最初のitemsループに、bicyclesエレメントを2番目のループにそれぞれ配置します。
情報メモヒント: 必要であれば、分割済みのエレメントを右クリックして[Move Up] (上に移動)、[Move Down] (下に移動)、[Delete] (削除)をクリックすることで、そのエレメントを移動または削除できます。
タスクの結果
{
"items":[
{
"make":"MBIKE",
"description":"27.5 inch electric mountain bike",
"price":"899.99"
},
{
"make":"EBIKE",
"description":"Electric hybrid bike",
"price":"999.99"
},
{
"make":"WBIKE",
"description":"Women's road bike",
"price":"299.99"
},
{
"make":"ESCOOT",
"description":"Camou electric scooter",
"price":"749.0"
},
{
"make":"EVSCOOT",
"description":"Folding electric velocity+ scooter",
"price":"599.99"
},
{
"make":"KSCOOT",
"description":"24 volt kid scooter",
"price":"299.99"
}
]
}FROM itemsbycategory
SELECT {
items = (
FROM bicycles
SELECT {
make = make,
description = description,
price = price
}
UNION ALL
FROM scooters
SELECT {
make = make,
description = description,
price = price
}
)
}