Loop Through Records and Perform Group by

[kal-tech]

I have input file as shown below. I am trying to go through the records and create an output file as shown below. I believe cross tab may do that. But unable to execute . Could you please share your subject matter expert thought.

Input File
Account ID	Team
1	KP
1	KD
1	LP
2	BD
3	CD
3	PD
3	KP
Output File
Account ID	Team
1	KP,KD,LP
2	BD
3	CD,PD,KP

[binuacs · Accepted solution]

@kal-tech  Summarize tool, group by Account Id, select Team - String - concatenate 

[kal-tech]

Hi Binuacs - Based on your recommendation, I created the attached  workflow. The aggregated data showing in 3 columns . How to bring the value in one columns.? The output file should have 2 columns only as shown above , not 4 as shown in my workflow.

[kal-tech]

I added a formula field and concatenate the field values. It is now working. Thank you "BINUACS" for your idea and help.

[binuacs]

@kal-tech you need only the summarise tool to get the desired output

[kal-tech]

Thank you @binuacs for simplifying the workflow and clarification