Skip to content

Snowflake Guide

Eric's another Big Data Blog

Primary Menu
  • Home
  • About Me
  • |
  • SQL
  • Security
  • JDBC

Tag: unpivot

The type of column ‘xxx’ conflicts with the type of other columns in the UNPIVOT list.

Posted on 11 September 202024 May 2021 by Eric Lin

UNPIVOT is a SQL standard function that allows users to transform columns into rows, and Snowflake also supports it. Please see below example on how to use it: You can see that the result turned the scores that were in each column of a row into seperate rows that still associated with original student ID. […]

Continue Reading
Eric Lin
Principal Cloud Support Engineer
@ Snowflake
Blogger | Runner | Ex-Cloudera
3 x SnowPro
Snowflake | Monash University
View Profile

Friendly Links

  • Cloudera Troubleshooting
  • RAYNIX 筆記

Recent Posts

  • How to Merge Variant columns in Snowflake
  • SQLCODE returns 0 in the catch block even the query failed due to invalid identifier
  • String object in Javascript UDF does not have the replaceAll() function
  • Create View Automatically From VARIANT Columns
  • Find Child Queries of a Stored Procedure
All rights reserved!
Copyright All rights reserved | Theme: Advance Blog by WPinterface.