Since mapping data flows became generally available in 2019, the Azure Data Factory team has been closely working with customers and monitoring various development pain points. To address these pain ...
Updated Sep 15, 2020
Version 2.0
Blog Post
Hi,
I'm not sure if this place is the correct to ask this if I'm wrong please let me know.
I have an Excel file that I'm processing using Mapping data flow... in this process, I remove Null values and some rows, and after this, my data have in the first row the names of the columns but in the sink activity my columns have names like _col1_, _col2_, etc... how I can set my first row as a header before all transformation process? I tried to use derived column and mapping columns but I need to do this process without set manually the names or by position.
Thanks for help 🙂