Blog Post

Azure Data Factory Blog
1 MIN READ

Unroll multiple arrays in a single Flatten step in ADF

Mark Kromer's avatar
Mark Kromer
Icon for Microsoft rankMicrosoft
Apr 21, 2023
You can now easily unroll multiple arrays inside a single Flatten transformation in Azure Data Factory and Azure Synapse Analytics using a data pipeline with a Mapping Data Flow.     ADF...
Updated Apr 21, 2023
Version 1.0
azure data factory
Azure Data Integration
Azure ETL
Manjunath_Narayan's avatar
Manjunath_Narayan
Copper Contributor
Jan 10, 2024

Mark Kromer looking at the data preview output, seems like the second level of flattening isn't happening, the cities which is mapped to output column "orderitems" is still displayed as an array, it should have displayed each record for "Plainsboro" and "Jersey".