Using a Postgres dataflow to split a comma-separated string into separate rows

Trying to split a comma-separated field into rows. Input looks like this:

 

JiraID   |   Zendesk IDs

1          |   5,6,7

 

Desired Output:

Jira ID | Zendesk ID

1             5

1             6

1             7

 

tried using unnest(string_to_array("Zendesk IDs", ',')::integer[]) 

 

but am getting errors that unnest(integer[]) not found.

 

Any other way?

 

Thanks!

Comments