AnsweredAssumed Answered

Remove 'Duplicates' and Merge the fields value into a single row

Question asked by sujith.vm901110 on Mar 14, 2017

Hello, 

 

I have design question , may looks straight forward to you..!!

 

I am getting below duplicate data from Source 

 

User,Phone1,Phone2,Phone3
employee16,Phone1,454-888-9874,Phone3
employee16,Phone1,Phone2,555-888-9969
employee16,454-777-8858,Phone2,Phone3

 

I need to convert this source data by removing these 'duplicate' rows but not the values in the Phone* columns

Result should look like below :

 

User,Phone1,Phone2,Phone3
employee16,454-777-8858,454-888-9874,555-888-9969

 

Please help. If it can be done without Groovy Script , its highly appreciated ..!!

 

Thanks..!

Outcomes