title: Convert comma delimited values in a column into rows
body: <p>I would like to convert comma-delimited values into rows in Redshift</p>
  <p>For example:</p>
  <pre><code>store  |location |products
  -----------------------------
  1      |New York |fruit, drinks, candy...
  </code></pre>
  <p>The desired output is:</p>
  <pre><code>store  |location | products
  ------------------------------- 
  1      |New York | fruit        
  1      |New York | drinks         
  1      |New York | candy     
  </code></pre>
  <p>Are there any simple solution that I could split the words based on delimiters and convert into rows? I was looking into this solution but it does not work yet: <a href="https://help.looker.com/hc/en-us/articles/360024266693-Splitting-Strings-into-Rows-in-the-Absence-of-Table-Generating-Functions" rel="nofollow noreferrer">https://help.looker.com/hc/en-us/articles/360024266693-Splitting-Strings-into-Rows-in-the-Absence-of-Table-Generating-Functions</a></p>
  <p>Any suggestions would be greatly appreciated.</p>