Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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