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
Jira ID | Zendesk ID
tried using unnest(string_to_array("Zendesk IDs", ',')::integer)
but am getting errors that unnest(integer) not found.
Any other way?