Alteryx Designer Desktop Discussions

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

Formula does not pull in data in output

richleeb2
Astéroïde

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 RÉPONSES 4
suby
Bolide

Please share us a screen shot.

DataNath
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
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
Astéroïde

Thank you this worked!

Étiquettes