Expand my Community achievements bar.

SOLVED

Combining multiple rows into 1 row from imported file

Avatar

Level 2

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
1 Accepted Solution

Avatar

Correct answer by
Level 3

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.

View solution in original post

9 Replies

Avatar

Level 3

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.

Avatar

Level 2

Hello

 

1. In the full file, there could be more that 2 duplicates to merge.

2. Yes that is what we want Header 2 to be --> Message 1 + Message 2

3. It doesn't have to be in that order

4. Our objective is to put the merge data as content on an email

Avatar

Level 2

- there could be more that 2 duplicates

- right now it's Message 1 + Message 2 - trying to find a way to add a break or insert next message to new line

-  this will depend on your sort

 

Avatar

Correct answer by
Level 3

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.

Avatar

Level 2
@anasso83525035 Thank you again for this.. is there a add new line in the enrichment activity?

Avatar

Level 3

Hello @peterd54639079,

 

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

Avatar

Administrator

Hi @peterd54639079,

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

Thanks!



Sukrity Wadhwa