I have table in teradata which has muliltple values in a column which are comma delimited. I am trying to separate the values into different rows
| Pk | Column |
|---|---|
| 1 | HK1, HK2, HK3 |
| 2 | HK2, HK3, HK4 |
| 3 | HK2, HK8, HK7 |
| 4 | HK9 |
My output should look like
| Pk | Column |
|---|---|
| 1 | HK1 |
| 1 | HK2 |
| 1 | HK3 |
| 2 | HK2 |
| 2 | HK3 |
| 2 | HK4 |
| 3 | HK2 |
| 3 | HK8 |
| 3 | HK8 |
| 4 | HK9 |
