This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 10-28-201606:51 PM - edited on 03-11-201909:25 AM by SydneyF
This 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:
Find and replace specific targets in your data (example attached in Text Input.yxzp)
Append user-entered data (example attached in Text Input.yxzp)
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 firstname.lastname@example.org if you’d like your creative tool uses to be featured in the Tool Mastery Series.
Stay tuned with our latest posts everyTool Tuesdayby followingAlteryxon Twitter! If you want to master all the Designer tools, considersubscribingfor email notifications.