Transposing the columns

Database

Transposing the columns

hello guys,

I want to transpose few rows into columns in teradata. please help me writing the SQL.

Input-- A

           B

           C

Output --  A   B  C

. i have tried a lot but counldn't find a solution.Please reply as soon as possible.

3 REPLIES

Re: Transposing the columns

Try with select tdstats.udfconcat(input1) from yourtable; You can remove the unwanted " and , using regexp_replace....

Re: Transposing the columns

I am not getting your point , i am new to teradata. Can you please explain more. thanks for the reply though.

Re: Transposing the columns