title: Azure Data factory to add additional rows in csv based on multiple values in a column
body: <p>I have an excel file in an Azure blob that I convert into csv file and perform some transformations also on that file. The excel file is a list of Product values for that day. So the columns are like Data, Product names, Value. The product names are a list of different products separated by space.</p>
  <p>How do I denormalize this dataset where each product name is expanded into a separate row.
  Example this table below</p>
  <pre><code>Date | Products | Value
  20-02-2019 | prod_1 prod_2 prod_3 | 43
  20-02-2019 | prod_4 | 32
  21-02-2019 | prod_1 prod_4 | 32
  21-02-2019 | prod_2 | 40
  </code></pre>
  <p>should transform as</p>
  <pre><code>Date | Product | Values
  20-02-2019 | prod_1 | 43
  20-02-2019 | prod_2 | 43
  20-02-2019 | prod_3 | 43
  20-02-2019 | prod_4 | 32
  21-02-2019 | prod_1 | 32
  21-02-2019 | prod_4 | 32
  21-02-2019 | prod_2 | 40
  </code></pre>
  <p>I've looked into mapping data flow and alter rows but they both need a database as a sink. I'm relatively new to ADF so wondering if there's a way to do such that the transformation is stored in a blob?</p>