title: Azure Data Flow: How to map csv to sql following table structure?
body: <p>I have a raw csv in azure blob as follows:</p>
  
  <p><a href="https://i.stack.imgur.com/nEzJ9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nEzJ9.png" alt="csv in blob"></a></p>
  
  <p>I want to transform it as follows so that I can map it to the table:</p>
  
  <p><a href="https://i.stack.imgur.com/h5C6c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h5C6c.png" alt="sql table structure"></a></p>
  
  <p>If this is not possible in Azure data flow, then at least can we convert CSV to the expected SQL table format using excel functions?</p>