18. How to combine Columnnames and columnvalues of two files into single file using mapping dataflow
In this video, we learnt how to combine columnnames and columnvalues coming from two different files into single file using mapping dataflow
#adf #azuredatafactory #datafactory #dataflow
Json1:
{"fields":
[
{"displayName":"RecId",
"fieldID":"1001"},
{"displayName":"Created DateTime",
"fieldID":"1002"},
{"displayName":"Created By",
"fieldID":"1003"},
{"displayName":"Created By ID",
"fieldID":"1004"},
{"displayName":"Last Modified DateTime",
"fieldID":"1005"}
]
}
Json2:
{
"FieldID:1001":"DS79237BWE09",
"FieldID:1002":"12/13/2021 11:35PM",
"FieldID:1003":"James Bond",
"FieldID:1004":"007",
"FieldID:1005":"09/10/2022 07:00AM"
}