Combining multiple rows into 1 row from imported file

Avatar

Avatar

peterd54639079

Avatar

peterd54639079

peterd54639079

30-10-2020

we have a file imported from a workflow. see sample below

 

Is there a way to combine row 1 and 2 using workflow?

 

Row#Header 1Header 2
1Customer 1Message 1
2Customer 1Message 2
View Entire Topic

Avatar

Avatar

anasso83525035

Avatar

anasso83525035

anasso83525035

02-11-2020

Hello,

 

Here's a solution but you will need to know the maximum duplicates possible in your file, and also have a field to correctly order the records and concatenate your message in the right order.

 

anasso83525035_10-1604339567344.png

 

  1. Load your file
  2. Fork to two transitions
  3. in first transition, add a deduplication based on the Header1anasso83525035_0-1604338880236.png

     

  4. Join the two transitions in an enrichment activity wih the deduplication transition as the main set in an N card linkanasso83525035_1-1604338928537.pnganasso83525035_3-1604338999543.png

     

  5. In the additional data tab add your new collection link and configure its parameters as follow anasso83525035_4-1604339128576.png

    Here I suppose that I may have as many as 5 duplicates max.

    In the data tab, I add the header2 corresponding to the Message:anasso83525035_5-1604339212647.png

    In the Sort tab, I order by the rowID (supposedly) to have the message in the correct order.

    anasso83525035_6-1604339319987.png

     

  6.  Last step is to add another enrichment to concatenate the 5 duplicates ordered by rowIDanasso83525035_7-1604339401084.png

     

    Here's what my file looks like:

anasso83525035_8-1604339454194.png

And final result in my workflow :

anasso83525035_9-1604339524925.png

 

Hope this is clear enough.