如何使用Jolt将此嵌套数据转换为下面提到的线性格式数据.需要为所有嵌套数据创建单独的条目.每条记录中都应该有5个数据,分别是Practice_loc、Prac_num、topID、s1和s2.
data个
[
{
"practice_loc": "120",
"prac_num": "234",
"topId": "t1",
"subList": [
{
"S1": "A1",
"S2": "B1"
},
{
"S1": "A2",
"S2": ""
}
]
},
{
"practice_loc": "334",
"prac_num": "233",
"topId": "plumcherry",
"subList": [
{
"SubID1": "A3",
"SubID2": ""
}
]
},
{
"practice_loc": "987",
"prac_num": "232",
"topId": "artica",
"subList": [
{
"SubID1": "A5",
"SubID2": "B7"
}
]
}
]
Expected Data个 我试过了,但没起作用,结果为空,请帮帮忙
[
{
"practice_loc": "120",
"prac_num": "234",
"topId": "t1",
"S1": "A1",
"S2": "B1"
},
{
"practice_loc": "120",
"prac_num": "234",
"topId": "t1",
"S1": "A2",
"S2": ""
},
{
"practice_loc": "334",
"prac_num": "233",
"topId": "plumcherry",
"SubID1": "A3",
"SubID2": ""
},
{
"practice_loc": "987",
"prac_num": "232",
"topId": "artica",
"SubID1": "A5",
"SubID2": "B7"
}
]