有一个由多个标题行组成的数据表示例
| | Song 1 | Song 2 | Song 3 | |---------------------------|----------------|----------------| | Artist | Perc % | Val $ | Perc % | Val $ | Perc % | Val $ | |-------------------------------------------------------------| | Q1 | 10% | 200$ | 15% | 250$ | | | | BW | 10% | 200$ | 10% | 200$ | | | | POD | 5% | 150$ | 10$ | 200$ | | | | | | | | | | | | SUM | 25% | 550$ | 25% | 650$ | | |
使用提供的数据集
{
"data": [{
"artistId": "A001",
"artistName": "Q1",
"songs": [{
"songId": "S001",
"songName": "Song 1",
"percentage": "10%",
"value": "$200"
},
{
"songId": "S002",
"songName": "Song 2",
"percentage": "15%",
"value": "$250"
}
]
},
{
"artistId": "A002",
"artistName": "BW",
"songs": [{
"songId": "S001",
"songName": "Song 1",
"percentage": "10%",
"value": "$200"
},
{
"songId": "S002",
"songName": "Song 2",
"percentage": "10%",
"value": "$200"
}
]
},
{
"artistId": "A003",
"artistName": "POD",
"songs": [{
"songId": "S001",
"songName": "Song 1",
"percentage": "5%",
"value": "$150"
},
{
"songId": "S002",
"songName": "Song 2",
"percentage": "10%",
"value": "$200"
}
]
}
],
"summary": [{
"songName": "Song 1",
"totalPercentage": "25%",
"totalValue": "$550"
},
{
"songName": "Song 2",
"totalPercentage": "25%",
"totalValue": "$650"
}
]
}
我想知道是否可以映射提供的数据集,以便使用角材表在样本表上获得类似的东西?不需要翻页.