title: ADF / Convert csv table to json
body: <p>I'm working on Azure Data Factory (I'm the beginner of it).
  I've assigned with the task where I've to convert the table(csv file) in JSON. I've started it by using Azure Mapping Flow. I get data from csv file as a source and transfer that data using pivot. After the pivot, I'm not able to find appropriate output plus the sink json is generating multiple json files. </p>
  
  <p>Here is my sample input data:</p>
  
  <p><a href="https://i.stack.imgur.com/OAEiu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OAEiu.png" alt="enter image description here"></a></p>
  
  <p>I want output as below:</p>
  
  <pre><code>[
      {
          "Article": "A1",
          "Catalog": "C2",
          "GlobalCatalog": "C1",
          "CatalogSegmentation": [
              "S1"
          ],
          "GlobalSegmentation": [
              "S1"
          ]
      },
      {
          "Article": "A2",
          "Catalog": "C2",
          "GlobalCatalog": "C1",
          "CatalogSegmentation": [
              "S1"
          ],
          "GlobalSegmentation": [
              "S1",
              "S2"
          ]
      },
      {
          "Article": "A1",
          "Catalog": "C3",
          "GlobalCatalog": "C1",
          "CatalogSegmentation": [],
          "GlobalSegmentation": [
              "S1"
          ]
      },
      {
          "Article": "A2",
          "Catalog": "C3",
          "GlobalCatalog": "C1",
          "CatalogSegmentation": [
              "S2"
          ],
          "GlobalSegmentation": [
              "S1",
              "S2"
          ]
      }
  ]
  </code></pre>