Hi, Since the no of output columns is a variable, I think we may have

Hello Frndz,
I have a table named product as shown below:
product_id product_name
1 AAA
1 BBB
1 CCC
2 PPP
2 QQQ
2 RRR

Now my output should be:
product_id product_name_1 product_name_2 product_name_3
1 AAA BBB CCC
2 PPP QQQ RRR

Question Posted / yuvaevergreen

4 Answers
12424 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / yuvaevergreen

Hi,
Since the no of output columns is a variable, I think we
may have to write a SP or macro to get the desired output.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain fastload in teradata?

1040

How to load specific no.of records using bteq, or fastload,or multiload

1693

What are the different functions performed in development phase?

1018

What is the difference between teradata and oracle?

959

Difference between star and snowflake schemas?

1056

What is the maximum number of dml can be coded in a multiload script?

1057

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

984

Describe the set operators in teradata.

956

Which is faster fastload or multiload?

1045

What do you mean by teradata intelliflex?

1041

What are the updated features of teradata?

996

What are the various reporting tools in the market?

991

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3318

What is meant by Teradata Gateway?

1010

In BTEQ, how are the session-mode parameters being set?

1089