title: Splitting concatenated values in table column using Dataweave
body: <p>I have sample data in my Salesforce table as given below:</p>
  
  <p><a href="https://i.stack.imgur.com/qLEQF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qLEQF.png" alt="[1]: https://i.stack.imgur.com/f6Y9R.png"></a></p>
  
  <p><strong>I am on Mule 3.9 and running dataweave 1.0.</strong>
  I need to use dataweave to read the above data (from a Salesforce table) and transform it into a JSON as given below:</p>
  
  <pre><code>[
        {"Id": "634594cc","Name": "Alpha","List": "AB01"},
        {"Id": "634594cc","Name": "Alpha","List": "AB02"},
        {"Id": "634594cc","Name": "Alpha","List": "AB03"},
        {"Id": "5d839e9c","Name": "Bravo","List": "CD01"},
        {"Id": "5d839e9c","Name": "Bravo","List": "CD02"},
        {"Id": "3a5f34d3","Name": "Charlie","List": null}
  ] 
  </code></pre>
  
  <p>As you can see above, the "List" column is what I need to split as separate arrays in the final JSON. It has data with semicolon at the begin, in between and in the end.</p>
  
  <p>Thanks in advance for your help.</p>