title: Extracting metadata in Azure Data factory
body: <p>I have a csv file</p>
  <pre><code>Customer,Gender,Age,City
  1,Male,23,Chennai
  4,Female,34,Madurai
  3,Male,23,Bangalore
  </code></pre>
  <p>My Azure SQL DB's table TAB_A has only one column: Column_Name
  I need to move the header of csv file into TAB_A such that the result is:</p>
  <pre><code>Column_Name
  Customer
  Gender
  Age
  City
  </code></pre>
  <p>Is it possible to achieve this functionality with ADF - Mapping Data flow without using Databricks/Python.</p>
  <p>I tried with Source - Surrogate Key - Filter. Able to extract header as row. Unable to transpose. Any pointers? Thanks.</p>