0 - 9 of 9 tags for transpose

Hi,
 
I have a quick question regarding processing of views.
 

Hi All,

I'm new to TD and need help converting rows into a single column; 

 

Sample input data.

 

ID   key2 Indicator  

123 ABC    A1

123 ABC    B1

123 ABC    C1

345 CDE    A1

345 CDE    B1

345 CDE    C1

567 XYZ     B1

567 XYZ     C1

 

Hi,
I have a data like below:

Tgt

Src

lvl

L3_Tab1.Col1

L2_Tab1.Col3

0

L3_Tab1.Col2

L2_Tab2.Col2

0

L3_Tab1.Col3

L2_Tab2.Col3

0

L3_Tab1.Col4

L2_Tab2.Col1

0

L2_Tab1.Col3

Hi All,
I'm new to TD. I need to transpose data from rows to columns. I'm not sure how to do it using PIVOT in teradata. Can anyone help me.
Sample input data.
ID Name English Maths Science
123 ABC   90       95       95
345 CDE   70       80       90
 
My output should look like,

Hi,
 
Can anyone provide me a logic to apply transpose on rows to columns without the use of any other files(like .sqls or Bteq)? I need to select this result from different tables and insert it into a table. I have used left outer joins but is there any other easy way to do this?
Input:-

Hello experts

We are designing a dimension of ITEMS (in a Point of sales DWH) as a table with Name-Value Pairs i.e. ITEM attributes stored as ROWS instead of COLUMNS.This ITEM table is joined to a fact table containing SALES $ and QUANTITY.

Say i have data like this

 

 

COLUMN A

COLUMN B

A

1

A

2

A

3

A

4

B

1

C

1

C

2

 

And i want the output to be in the below format...

Hallo Everyone

I have question on transposing a set of columns into rows.

For example,

 

C1

C2

C3

COUNT

C5

C6

C7

C8

C9C

C10

C11

C12

C13

C14

C15

C16

In the past I have used Recursive and Rank Partition By to convert rows to columns. Now I have a new situation. I have data:
AccT_id Cust_id
10XXXXX1 85314587
10XXXXX1 92458714
5XX0XXX5 2587452
5XX0XXX5 4258702
5XX0XXX5 54782142
5XX0XXX5 67842521
5XX0XXX5 85745872

I need to place the cust_id into a colmun as:
Acct_id Cust_id1 Cust_id2 Cust_id3 Cust_id4 Cust_id5 Cust_id(N)
10XXXXX1 85314587 92458714
5XX0XXX5 2587452 4258702 54782142 67842521 85745872