Tratamento de Json

[hugoscaper]

Prezados,

Estou com um cenário que estou precisando do seguinte:

Tenho um json com esses campos:
facetsname facetsresultscount facetsresultsuniqueCount
June2 2023 2126569,2272014 1070484,1136192
June1 2023 2126569,2272014 1070484,1136192

e a saida gostaria que fosse assim:

June2 2023 2126569, 1070484
June1 2023 2272014, 1136192

[carlosteixeira]

@hugoscaper manda o Json ou parte dele...

Abraços

[hugoscaper]

[
{
"facetsname": "June2 2023",
"facetsresultscount": "2126569,2272014",
"facetsresultsuniqueCount": "1070484,1136192",
"metadata_accounts_0": "1282084",
"metadata_beginTime": "2023-06-01T03:00:00Z",
"metadata_beginTimeMillis": "1685588400000",
"metadata_contents_contentsalias": "Acessos_Unicos,Volume_Acessos",
"metadata_contents_contentscontents_attribute": "userBankAccount,userBankAccount",
"metadata_contents_contentscontents_function": "uniquecount,count",
"metadata_contents_contentscontents_simple": "1,1",
"metadata_contents_contentsfunction": "alias,alias",
"metadata_endTime": "2023-06-03T03:00:00Z",
"metadata_endTimeMillis": "1685761200000",
"metadata_eventType": "Transaction",
"metadata_eventTypes_0": "Transaction",
"metadata_facet": "Date of timestamp",
"metadata_facetExpression": "`dateof`(`timestamp`)",
"metadata_guid": "9dfd5c23-5165-86b2-38f6-f8729c760bc6",
"metadata_limit": "2000",
"metadata_offset": "0",
"metadata_openEnded": "0",
"metadata_rawCompareWith": "",
"metadata_rawSince": "'2023-06-01'",
"metadata_rawUntil": "'2023-06-03'",
"metadata_routerGuid": "9dfd5c23-5165-86b2-38f6-f8729c760bc6",
"performanceStats_exceedsRetentionWindow": "0",
"performanceStats_inspectedCount": "30769016",
"performanceStats_matchCount": "4398337",
"performanceStats_omittedCount": "246",
"performanceStats_wallClockTime": "6081",
"totalResult_resultscount": "4398583",
"totalResult_resultsuniqueCount": "1774029",
"unknownGroup_resultscount": "0",
"unknownGroup_resultsuniqueCount": "0"
},
{
"facetsname": "June1 2023",
"facetsresultscount": "2126569,2272014",
"facetsresultsuniqueCount": "1070484,1136192",
"metadata_accounts_0": "1282084",
"metadata_beginTime": "2023-06-01T03:00:00Z",
"metadata_beginTimeMillis": "1685588400000",
"metadata_contents_contentsalias": "Acessos_Unicos,Volume_Acessos",
"metadata_contents_contentscontents_attribute": "userBankAccount,userBankAccount",
"metadata_contents_contentscontents_function": "uniquecount,count",
"metadata_contents_contentscontents_simple": "1,1",
"metadata_contents_contentsfunction": "alias,alias",
"metadata_endTime": "2023-06-03T03:00:00Z",
"metadata_endTimeMillis": "1685761200000",
"metadata_eventType": "Transaction",
"metadata_eventTypes_0": "Transaction",
"metadata_facet": "Date of timestamp",
"metadata_facetExpression": "`dateof`(`timestamp`)",
"metadata_guid": "9dfd5c23-5165-86b2-38f6-f8729c760bc6",
"metadata_limit": "2000",
"metadata_offset": "0",
"metadata_openEnded": "0",
"metadata_rawCompareWith": "",
"metadata_rawSince": "'2023-06-01'",
"metadata_rawUntil": "'2023-06-03'",
"metadata_routerGuid": "9dfd5c23-5165-86b2-38f6-f8729c760bc6",
"performanceStats_exceedsRetentionWindow": "0",
"performanceStats_inspectedCount": "30769016",
"performanceStats_matchCount": "4398337",
"performanceStats_omittedCount": "246",
"performanceStats_wallClockTime": "6081",
"totalResult_resultscount": "4398583",
"totalResult_resultsuniqueCount": "1774029",
"unknownGroup_resultscount": "0",
"unknownGroup_resultsuniqueCount": "0"
}
]

segue o json

[carlosteixeira]

@hugoscaper isso vai ser uma constante? Digo o primeiro pega o primeiro e a segunda linha pega o segundo?

June2 2023 2126569, 1070484
June1 2023 2272014, 1136192

[hugoscaper]

vai ser variavel, pois faço um select em uma tabela e preciso trazer varias datas.

[carlosteixeira]

@hugoscaper Qual será a regra? Sem regra não dar muito certo.