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

Hi,

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?

Thanks.

Outcomes