Hi , I have a nested indexed json that I want to flatten using Azure Data Flow, could you help me out with a plausible solution.

Abheek Bhowmik 1 Reputation point
2022-09-28T13:12:07.817+00:00

Source Json coming from Azure Blob as an entry in a single column.
{
"1": {
"startDay": ["Monday", "Tuesday", "Wednesday", "Thursday"],
"startTime": "9:00AM",
"endTime": "10:00AM",
"appointmentType": "104",
"repeatFreq": "1",
"endBy": "infinite"
},
"2": {
"startDay": ["Monday", "Tuesday", "Wednesday", "Thursday"],
"startTime": "10:00AM",
"endTime": "11:00AM",
"appointmentType": "104",
"repeatFreq": "1",
"endBy": "infinite"
}
}

this needs to be flattened to :
{
"Column_ID":"1",
"startDay": ["Monday", "Tuesday", "Wednesday", "Thursday"],
"startTime": "9:00AM",
"endTime": "10:00AM",
"appointmentType": "104",
"repeatFreq": "1",
"endBy": "infinite"
}
{
"Column_ID":"2",
"startDay": ["Monday", "Tuesday", "Wednesday", "Thursday"],
"startTime": "10:00AM",
"endTime": "11:00AM",
"appointmentType": "104",
"repeatFreq": "1",
"endBy": "infinite"
}

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,711 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Samy Abdul 3,366 Reputation points
    2022-09-28T13:26:55.4+00:00