community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Tool Mastery | Text Input

Community Content Engineer
Community Content Engineer
Created on

Text Input.pngThis article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Text Input Tool on our way to mastering the Alteryx Designer:

 

With the Input Data Tool (master it here), our Connector Tools and the Download Tool (master it here), data in the Designer is aplenty. But what about manually entered user data? In analytics, we’re often trying to avoid human-entered data (unless we’re cleaning it) because it is more prone to error. In spite of the risks, there are a number of situations that manually entered data can be useful in Alteryx. However, it’s dangerous to go alone; take the Text Input Tool and simplify those instances with the techniques below:

 

 

1.png

 

  • Find and replace specific targets in your data (example attached in Text Input.yxzp)

2.png

 

  • Append user-entered data (example attached in Text Input.yxzp)

 3.png

Note: You can use the Join Tool (master it here) and a join condition field to establish a lookup table relationship as well.

 

 

By now, you should have expert-level proficiency with the Text Input Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know at community@alteryx.com if you’d like your creative tool uses to be featured in the Tool Mastery Series.

 

Stay tuned with our latest posts every Tool Tuesday by following Alteryx on Twitter! If you want to master all the Designer tools, consider subscribing for email notifications.

Attachments
Comments
Atom

For image "Find and replace specific targets in your data " why does the first address drop the E from ME?

Atom

For image "Append user-entered data" why November rather than October?

Asteroid

@KTRomero, There was an issue with how large the field was (the workflow has it set up for 44 characters, and after the delimiter, it was dropping off numbers and letters). After throwing a select tool and adjusting the size, it runs fine now.

 

For the second one, I am guessing it is November-based report on last month's sales by rep. So, December's report would have November's numbers, and so on.

 

The examples are a bit strange without context or seeing the formulas, but they should still be helpful nonetheless. 

 

Thanks for the article, @MattD!

-AD