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

Combining multiple rows into 1 row from imported file

Avatar

Avatar
Validate 1
Level 1
peterd54639079
Level 1

Likes

0 likes

Total Posts

16 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
peterd54639079
Level 1

Likes

0 likes

Total Posts

16 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
peterd54639079
Level 1

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
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

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
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

09-11-2020

Hello @peterd54639079,

 

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

Avatar

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

146 likes

Total Posts

884 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

146 likes

Total Posts

884 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile
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
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

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.