creating nested json

[yosiasz]

hello

for the following json

{
"realtime_start": "2024-08-14",
"realtime_end": "2024-08-14",
"date": "2024-02-01",
"value": "311.054"
},
{
"realtime_start": "2024-08-14",
"realtime_end": "2024-08-14",
"date": "2024-03-01",
"value": "312.230"
}

I want to generate

{
	"194701": {
		"date": "1947-01-01",
		"value": "21.48"
	},
	"194701": {
		"date": "1947-01-01",
		"value": "21.48"
	}
}

what would be the jsonata way of doing this please?

[mattbaileyuk]

The intending mapping is unclear here in your example output. Should date and value come from each of the original objects - but what about the key (which is identical, and so not valid JSON)?