title: Split array of values into rows in Amazon Redshift
body: <p>How can i split an array of values in a column into corresponding rows in Redshift using a delimiter (,) ?</p>
  
  <p>Input Data:-  </p>
  
  <pre><code>—————————————  
  Empid | Items  
  —————————————  
  1001| A, B  
  1002| B  
  1003| C, D, E  
  </code></pre>
  
  <p>Required Output:-  </p>
  
  <pre><code>—————————————  
  Empid | Items  
  —————————————  
  1001| A  
  1001| B  
  1002| B  
  1003| C  
  1003| D  
  1003| E  
  </code></pre>
  
  <p>Any help is appreciated.</p>
  
  <p>Thanks</p>