please provide logic for this

vsandu · Post by **vsandu** » Tue Apr 17, 2012 11:40 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Apr 18, 2012 12:07 am

Vertical pivot.

kandyshandy · Post by **kandyshandy** » Wed Apr 18, 2012 12:07 am

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

vsandu · Post by **vsandu** » Wed Apr 18, 2012 12:24 am

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

kandyshandy · Post by **kandyshandy** » Wed Apr 18, 2012 12:34 am

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

sreewin7 · Post by **sreewin7** » Mon May 14, 2012 3:00 pm

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