Free Trial

Alteryx Designer Desktop Discussions

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

Output Text

aaronmcasasola
7 - Meteor

Hello Everyone,

 

I made a workflow that creates a wire harness creation list.  By inputting the nomenclature of the desire model.  The issue that I am facing is that I want it to also output a special text whenever a specific nomenclature is called.  EX: By inputting TPWCCMV0400D4-MM, I want to output on the pdf: "Use label 1,2, and 3."

 

2.jpg1.jpg

 

 

 

 

 

 

 

 

 

 

 

 

Please help me with this!

2 REPLIES 2
danilang
19 - Altair
19 - Altair

Hi @aaronmcasasola 

 

Use a formula tool to create a new field called SpecialText.  In the Formula use something like

 

IF [Model Number] = "TPWCCMV0400D4-MM" then
   "Use label 1,2, and 3"
else
   Null()
endif

 

 

Add [SpecialText] as a field in your Report Text Tool.  It will either show the special text or a blank line, depending on the model number.  If you have several variations of the special text based on model number, consider putting these in a text box and using Find Replace to build up the SpecialText field

 

Dan

aaronmcasasola
7 - Meteor

Awesome! Thank you!

Labels
Top Solution Authors