issue once using separator
in the report text

Question

Hi All!

In my workflow I used table, summarize and report text tools to send emails. When I want to use field [Concat_VenueGatewayName] in the body of my email in the report text I have an issue because the data are next to each other and I would like to have them one under the other. For this purpose I created before separator 
 in the summarize tool but it doesnt work. Could you please help with below? In the body of the Email I would like to have unique data with VenueGatewayName the same as I have in the table but just the unique one without repetition.

bond workflow - test.yxmd

3.png

2.png

1.png

davidskaife · Answer

Hi @howyoudoing

I'm getting the workflow behaving as expected.

Did you try upgrading your version of Alteryx as suggested by @binu_acs in the other thread?

Couple of other things you can try if the upgrade doesn't fix the issue:

* remove the Formula tool at the end, you shouldn't need this as the Summerize tool should be doing the job of creating the newline for each record in the concatenation
* completely remove the Report Text tools, and re-insert them from fresh just in case something is 'stuck'

Just out of interest do you have AMP Engine on or off? Try switching it off (if its on), or on (if its off) to see if that changes the behaviour