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!
