How can I separate a comma-delimited list in a column into separate rows?

Get Help
1

I have data that is collected in the following format:

VALUE1
a,b,c,d

How can I change the format to:
VALUE1
a
b
c
d

as 4 separate rows?

2

SELECT *
FROM string_to_table('1,2,3,4,5', ',') token

image
image1533×773 15.6 KB

3

Unfortunately this gives me a SQL compilation error:

SQL compilation error: syntax error line 2 at position 20 unexpected '('. syntax error line 2 at position 37 unexpected ')'.
4

The function is database type specific. What database are you using?

Personally, I'd never do this in Metabase but create a view in the database to do the work. Much easier to maintain.