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

Accepted Solutions (1)

Accepted Solutions (1)

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.

Answers (3)

Answers (3)

Avatar

Avatar

anasso83525035

Avatar

anasso83525035

anasso83525035

09-11-2020

Hello @peterd54639079,

 

Curious to know if you got a chance to test the solution provided ?

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

11-11-2020

Hi @peterd54639079,

Were you able to resolve this query with the given solution? Do let us know.

Thanks!

Avatar

Avatar

anasso83525035

Avatar

anasso83525035

anasso83525035

31-10-2020

Hey @peterd54639079 

 

Couple questions here to be able to help you with this.

 

  • In your full file, are there always only two duplicates to merge ?
  • What should the Header 2 field look like when merged : Message 1+Message 2 ?
  • If so, does the line with the lower row number always have the start of the Message ?
  • What is the final objective of this ? Updating a table ? If so it may be easier to update twice directly rather than trying to merge the data beforehand.

Thanks.