Hey guys, I am a newbie with Alteryx and I have a workflow where I am creating a concatenated field that I am trying to include in the middle of an email's body separated by newlines. It is a list of website links generated based on IDs. I am able to create individual hyperlinks using the concatenate tool, but they all appear on the same line in the body of the email.
I have seen solutions involving tables that I can't get to work as throwing the data into a table removes all of the formatting that I have created for the body of the email. In the examples I have seen, they WANT the table format as the body of the email, and that is NOT what I am looking for - I want a standard email body with a list of websites on new lines.
Is there any way to have Concat_link concatenate properly in the middle of an email's body with newlines? Or am I perhaps misunderstanding how to use the table method?
The example I have attached will generate the 4 individual hyperlinks that work when placed in the body of the email, but the newline is not picked up by the email tool. The browse tool shows exactly what I am trying to achieve in the correct formatting.
Here are the solutions involving Tables:
Solved! Go to Solution.
Thanks for looking into this - both of those unfortunately have the same problem of wanting the format to stay as a table. The email tool recognizes the newlines when put through the table tool, but having the body of the email be a table wouldn't look great for what I'm trying to do.
I have tried <br> as well but the email tool ignores it.
@Brett_A You should be able to use the regex_replace trick to replace the newline character with an html line break character <br />
REGEX_Replace([Body],"(\n)+","<br />")
Then it comes through as expected in an email when I tested it:
Hope that helps!
That worked perfectly, thank you! Guess I was too focused on the Table part of those solutions haha.