Alteryx Designer Desktop Discussions

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

Formula does not pull in data in output

richleeb2
8 - Asteroid

I have an email paragraph in the formula tool, and I want to pull in a data field from another column.  I enter the [name of column] in the body of the paragraph, but it doesn't pull the value and the output just shows [name of column].  What am I missing?

4 REPLIES 4
suby
11 - Bolide

Please share us a screen shot.

DataNath
17 - Castor

If I'm understanding the issue correctly, you'll need to split the email body up and insert the field in between, something like this:

 

(What I assume is) your current approach:

 

DataNath_1-1660859080130.png

 

Breaking the main string into 2 parts, with the field inserted between:

 

DataNath_2-1660859109268.png

 

If this isn't the issue, please can you provide some extra information and preferably some screenshots, or share your workflow if possible!

SPetrie
12 - Quasar

Did you breakup the paragraph before inserting the column name?

You have to end the quote and add the data in with a +

If you dont break it, its taking the literal text.

SPetrie_0-1660859330498.png

 

richleeb2
8 - Asteroid

Thank you this worked!

Labels