title: How to parse comma separated values in one column and convert each distinct value as a column for each record using snowflake?
body: <p>I have a table like this - I want to parse each row of the message column and create a new table with the following format by taking each distinct 2-digit prefix of the value and setting that as a new column. How do I write this in snowflake?
  <a href="https://i.stack.imgur.com/osdFe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/osdFe.png" alt="enter image description here" /></a></p>