Blog Post

Azure Data Factory Blog
2 MIN READ

ADF Adds Hierarchical & JSON Data Transformations to Mapping Data Flows

Mark Kromer's avatar
Mark Kromer
Icon for Microsoft rankMicrosoft
Sep 28, 2019
The Azure Data Factory team has released JSON and hierarchical data transformations to Mapping Data Flows. With this new feature, you can now ingest, transform, generate schemas, build hierarchies, a...
Published Sep 28, 2019
Version 1.0
Azure Data Factory
JSON
Mapping Data Flows
Mark Kromer's avatar
Mark Kromer
Icon for Microsoft rankMicrosoft
Nov 25, 2019

In the Copy Activity, you can map these structures to targeted column names in your CSV flat file in the Sink mapping.

 

In Data Flows, you will create a Derived Column and build a flat structure of columns that map to the different structures.

 

Data Flows are enhancing the H2R capabilities in the tool, but for now, this is the mechanism to use.