Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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