13. How to unpivot sql columns and convert it into nested json using mapping dataflow

Опубликовано: 11 Октябрь 2024
на канале: Azure Content : Annu

407

In this video we learnt how to unpivot sql columns and convert it into nested json using mapping dataflow
#adf
#datafactory
#azuredatafactory
#azuresynapseanalytics

Input dataset:
EntityName customField1 CustomField2
------------------------------------------
AA01 NGO21 2022-01-01
AA02 BS34 2022-03-01

Expected Output dataset:
[
{
"EntityName": "AA01"
"OtherFields":[{"customFieldName": "custom field 1, "customFieldValue": "NGO21"},{"customFieldName": "custom field 2", "customFieldValue": "2022-01-01"} ]
},
{
"EntityName": "AA02"
"OtherFields":[{"customFieldName": "CustomField1", "customFieldValue": "BS34"},{ "CustomFieldName":"CustomField2", "customFieldValue" : "2022-03-01"}]
}
]