AnsweredAssumed Answered

Is there any way to concatenate values from Column  into a single Column ?

Question asked by naveenaboppana558916 on Jul 17, 2016
Latest reply on Jul 19, 2016 by Pavan_Sirasanambedu


Is there a way to Concatenate Values from a source based on Unique Id Filed?


Source Data:

Id  Name

1   abc

1   def

1   ghi

2   xxy

2   xyz


Expected Output:

Id     Name

1      abc,def,ghi

2      xxy,xyz


--->Target should contain Distinct Id values.

-->On taking consideration of distinct "Id" Filed values from source ,Name Field should be populated (Values to be concatenated using delimiter ",").


Any Suggestions?