Convert multiple rows into single row

Hi...
i have sourse like
name,city
johny,newyork
johny,mumbai
johny,del
want output like.....
name,city1,city2,city3
johny,nework,mumbai,delhi
-----------------------------------------
thanks in advance...

Questions by sai3689   answers by sai3689

Showing Answers 1 - 9 of 9 Answers

Abhishek Surkar

  • Mar 27th, 2015
 

Use Pivot Stage-->open Pivot stage select Properties tab select Pivot Type = Vertical -->select Pivot Properties tab click Check Group by for Name --> click Check Pivot for city -->Make Array size =4 -->
Map Output columns to output link and click Ok -->
Compile --> Run

  Was this answer useful?  Yes

RAM

  • Aug 27th, 2015
 

without using Pivot stage..
Source --> COPY
COPY --> Head(1) --> File1
COPY --> Head(2) -->Tail(1) --> File2
COPY --> Tail(1)-->File3
now merge all file1,file2,file3 --> Target.
Pls check it may work.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions