AnsweredAssumed Answered

Flat file multiple rows to one row - output new flat file

Question asked by buskirkr465479 on Feb 14, 2017
Latest reply on Feb 21, 2017 by Seth Duda

I have a flat file I extracted data from Salesforce via boomi with multiple rows and need to get them to one row using the 'Case Number' as the qualifier.  I need to convert the multiple rows flat file to a single row flat file

 

Example

 

Source File generated from boomi (see attachement) (.csv)

Case Number, Product ID

1234,100   

1234,200

1234,300

 

Expected File (.csv)

Case Number, Case Product

1234,100,200,300

Attachments

Outcomes