Using synapse data flow I want to transform the json format bellow into a tabular format with one column as data and the other as the number
{
"2023-12-11T00:00:00+01:00": 1272,
"2023-12-12T00:00:00+01:00": 1436,
"2023-12-13T00:00:00+01:00": 1173,
"2023-12-14T00:00:00+01:00": 1083,
"2023-12-15T00:00:00+01:00": 1231,
"2023-12-16T00:00:00+01:00": 854,
"2023-12-17T00:00:00+01:00": 805,
"2023-12-18T00:00:00+01:00": 1021,
"2023-12-19T00:00:00+01:00": 1112,
"2023-12-20T00:00:00+01:00": 1192,
"2023-12-21T00:00:00+01:00": 1071,
"2023-12-22T00:00:00+01:00": 1089,
"2023-12-23T00:00:00+01:00": 942,
"2023-12-24T00:00:00+01:00": 879,
"2023-12-25T00:00:00+01:00": 911,
"2023-12-26T00:00:00+01:00": 1167,
"2023-12-27T00:00:00+01:00": 1070,
"2023-12-28T00:00:00+01:00": 1172,
"2023-12-29T00:00:00+01:00": 953,
"2023-12-30T00:00:00+01:00": 780,
"2023-12-31T00:00:00+01:00": 749,
"2024-01-01T00:00:00+01:00": 703,
"2024-01-02T00:00:00+01:00": 1045
}
| Date | Total |
|---|---|
| 2023-12-11 | 1272 |
| 2023-12-12 | 1436 |
| 2023-12-13 | 1173 |
| 2023-12-14 | 1083 |
New contributor
Euclides Jaime is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.