Query Optimization in Snowflake (QOSF)

Split a column value into multiple columns based on delimiter using PIVOT

Input Data

ROW_VALUE
Bob,CSE 510,CSE 594,CSE 310
Angela,CSE 580,CSE 594,CSE 320,CSE 510,CSE 310

Query

with unpivoted_data as (
  select *
  from imported_data,
  table(split_to_table(row_value, ',')) as t1
)
select *
from unpivoted_data
pivot (min(value) for index in (ANY));

Query Output

SEQ	1	2	3	4	5	6
2	Angela	CSE 580	CSE 594	CSE 320	CSE 510	CSE 310
1	Bob	CSE 510	CSE 594	CSE 310

See also:

• Support for ANY keyword in the Snowflake’s PIVOT IN list
• Split a column value into multiple columns based on delimiter using PIVOT
• UNPIVOT multiple columns in Snowflake

This site is open source. Improve this page.