unpivot

UNPIVOT(group_count, …)

Convert columns to rows based on groups

Args:

  • group_count (int): Number of columns which forms a new row

  • … (any): dynamic column list

Returns:

rows:

Example:
1select UNPIVOT(1,"A",b,c) emits(a varchar(10), b varchar(10),c varchar(10)),a,b
2from (
3   select '1' as a,'2' as b,'3' as c union all
4   select '4','9','5'
5)
6returns for 1,2,3,4,9,5 a row b and c is empty

```sql select UNPIVOT(2,"A",b,c) emits(a varchar(10), b varchar(10),c varchar(10)),a,b from ( select '1' as a,'2' as b,'3' as c union all select '4','9','5' ) ```