Concatenate Multiple Rows Into One Unique Identifier
Hi All,
I need to concatenate multiple rows into one unique identifier
So, my unique identifiers are Name and email_id column.
It is 1:M relationship like same name and email_id can have n number of different products, now i should
So, let's say Name=xyz and email_id=xyz@xyz.com has 5 rows with different product info for them.
#Name #email_id # product
xyz xyz@xyz.com Ora
xyz xyz@xyz.com sql
xyz xyz@xyz.com siebel
xyz xyz@xyz.com erp
xyz xyz@xyz.com crm
My end result would be after concatenation (having / as delimeter between each concatenated row):
#Name #email_id # product
xyz xyz@xyz.com Ora/sql/siebel/erp/crm
Help please, after many attempts I can't seem to get it to work. Thank in advance
Edited by: user13080645 on 22-Jan-2011 07:33