Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Combining multiple rows into 1 row from imported file

peterd54639079
Level 2
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
anasso83525035
Correct answer by
Level 3
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

7 Replies
anasso83525035
Level 3
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.

peterd54639079
Level 2
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

peterd54639079
Level 2
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

 

anasso83525035
Correct answer by
Level 3
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

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

Hello @peterd54639079,

 

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

Sukrity_Wadhwa
Employee
Employee

Hi @peterd54639079,

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

Thanks!