源 JSON:
[
{
"dimensions": [
{
"id": "1546382552",
"name": "BLOOM FACE MASK DAY SPA AM APOTHEKA"
},
{
"id": "2024-12-01",
"name": ""
}
],
"metrics": [
364,
20
]
},
{
"dimensions": [
{
"id": "857640546",
"name": "Vitamin A"
},
{
"id": "2024-12-02",
"name": ""
}
],
"metrics": [
310,
22
]
}
]
来自维度数组:
id
从第一个对象开始应该写为字段sku
,并name
写为sku_name
id
来自第二个对象应该写为字段date
“
来自指标数组:
- 数组中第一个元素应写为
session_view
,第二个元素应写为session_view_search
我尝试过(但失败了):
[
{
"operation": "shift",
"spec": {
"*": {
"dimensions": {
"*": {
"0": {
"id": "[&2].sku",
"name": "[&2].sku_name"
},
"1": {
"id": "[&2].date"
}
}
},
"metrics": {
"0": "session_view",
"1": "session_view_search"
}
}
}
}
]
最后我期望:
[
{
"sku": 1546382552,
"sku_name": "BLOOM FACE MASK DAY SPA AM APOTHEKA",
"date": "2024-12-01",
"session_view": 364,
"session_view_search": 20
},
{
"sku": 857640546,
"sku_name": "Vitamin A",
"date": "2024-12-02",
"session_view": 310,
"session_view_search": 22
}
]
应该从最外层进行细分,同时删除额外的中间嵌套层,例如
网站上的演示Jolt Transform Demo Using v0.1.1是: