We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


UDF for Row - Column transpose | Dynamic columns — Vertica Forum

UDF for Row - Column transpose | Dynamic columns

MS_1MS_1
in General Discussion
Friends


Please share if anyone has ever written a UDF that does below thing.

Row - column transpose with dynamic number of columns .

Here is the example:

image


NOTE: THERE COULD BE THE CASE THAT NUMBER OF SUBJECTS MIGHT BE DIFFRENT FOR DIFFERENT STUDENTS.

ALSO, SELECT QUERY SHOULD BE ABLE TO HANDLE DYNAMIC NUMBER COLUMNS WHEN NEW SUBJECT IS ADDED.

Thanks
Mahesh

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...