I have an array of objects, similar to the first JSON shown below.
My goal is to group and zip this array based on the attribute name. If the name matches another object, I want to combine them and set all attributes and values into a 'fields' array.
[
{
"name":"D1D1",
"attritube":"HOST_NAME",
"value_inv":"TEST1",
"value_prod":"TESTA1"
},
{
"name":"D1D1",
"attritube":"HOST_NAME",
"value_inv":"TEST2",
"value_prod":"TESTB1"
},
{
"name":"D2D2",
"attritube":"COMMENTS",
"value_inv":"TEST1",
"value_prod":"TESTA1"
}
]
[
{
"name":"D1D1",
"fields":[
{
"attritube":"HOST_NAME",
"value_inv":"TEST1",
"value_prod":"TESTA1"
},
{
"attritube":"HOST_NAME",
"value_inv":"TEST2",
"value_prod":"TESTB1"
}
]
},
{
"name":"D2D2",
"fields":[
{
"attritube":"COMMENTS",
"value_inv":"TEST1",
"value_prod":"TESTA1"
}
]
}
]