UNPIVOT Operator

Moderator: NorbertKrupa

Post Reply
User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

UNPIVOT Operator

Post by becky » Fri Feb 15, 2013 4:29 pm

Hi,

Oracle 11g has a cool feature in the UNPIVOT operator that converts column-based data into separate rows.

Is there some sort of trick we can do in Vertica to do the same?
THANKS - BECKSTER
Top
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:
Contact JimKnicely

Re: UNPIVOT Operator

Post by JimKnicely » Fri Feb 15, 2013 5:43 pm

Hi Becky,

Instead of responding here I created another post titled "Converting Columns to Rows" here:

viewtopic.php?f=63&t=831

I hope it helps!
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Top
Post Reply

Return to “New to Vertica SQL”