Loop Through Records and Perform Group by

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

Developer

Accepted answers

binu_acs

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

All comments

binu_acs

@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.

Loop Through Records and aggregate.yxmd

kal-tech

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

binu_acs

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

kal-tech

Thank you @binu_acs for simplifying the workflow and clarification

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703