Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

issue once using separator\n in the report text

howyoudoing
8 - Asteroid

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 \n 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.

1 REPLY 1
DavidSkaife
13 - Pulsar

Hi @howyoudoing 

 

I'm getting the workflow behaving as expected.

 

Did you try upgrading your version of Alteryx as suggested by @binuacs 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

Labels
Top Solution Authors