DSXchange

Hello,
This is My input data
EID ENAME LOC
1111 SUMAN HYD
2222 MURALI DEL
3333 VENKAT CHN
1111 SUMAN BAN
2222 MURALI HYD
3333 VENKAT BAN
1111 SUMAN CHN
2222 MURALI MUM
3333 VENKAT PUN
my out put should be like this
EID ENAME LOC
1111 SUMAN HYD,BAN,CHN
2222 MURALI DEL,HYD,MUM
3333 VENKAT CHN,BAN,PUN

Any one please help me logic for this

Vertical pivot.

Sort and a vertical pivot. Search here & you will find many..

kandyshandy wrote:Sort and a vertical pivot. Search here & you will find many..

thanks kandyshandy ' for providing logic And is there any logic to do same by using transformer

Vertical pivot can be implemented either in a transfomer or in a pivot stage. Search here for vertical pivot.

If you have idea , how to use pivot in excel it is mostly same like this.

viewtopic.php?t=89442

This link will help you.

Thanks
Sree