


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 1 | Header 2 |
1 | Customer 1 | Message 1 |
2 | Customer 1 | Message 2 |
Views
Replies
Sign in to like this content
Total Likes
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.
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:In the Sort tab, I order by the rowID (supposedly) to have the message in the correct order.
Here's what my file looks like:
And final result in my workflow :
Hope this is clear enough.
Views
Replies
Sign in to like this content
Total Likes
Hey @peterd54639079
Couple questions here to be able to help you with this.
Thanks.
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes
- 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
Views
Replies
Sign in to like this content
Total Likes
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.
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:In the Sort tab, I order by the rowID (supposedly) to have the message in the correct order.
Here's what my file looks like:
And final result in my workflow :
Hope this is clear enough.
Views
Replies
Sign in to like this content
Total Likes
Views
Replies
Sign in to like this content
Total Likes
Hi @peterd54639079,
Were you able to resolve this query with the given solution? Do let us know.
Thanks!
Views
Replies
Sign in to like this content
Total Likes