Teradata : Transpose columns to rows

Scenario - Need to convert columns in a table to rows

Source table Query :

select * from <table>\n

Answer set :

We need to transform the above answer set as below. We need to get the column name entry in each row with their corresponding values as shown below:

Col1    Col2\n\nJOB1    161\nJOB2    38\n

Solution:

if you need to get the column names as values you need to write them as literals:

SELECT 'Job1', job1 FROM TABLE\nUNION ALL \nSELECT 'Job2', job2 FROM TABLE\n

nVector

posted on