Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Tool Mastery

Explore a diverse compilation of articles that take an in-depth look at Designer tools.
Become a Tool Master

Learn how you can share your expertise with the Community

LEARN MORE

Tool Mastery | Text Input

MattD
Alteryx Alumni (Retired)
Created

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.

Additional Information

Click on the corresponding language link below to access this article in another language -

Attachments
Comments
KTRomero
5 - Atom

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

KTRomero
5 - Atom

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

ADerbak
11 - Bolide

@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

DunyaS
7 - Meteor

Thanks for asking and answering . Wasn't sure why it was gone but then I am just starting out. I have put another one in between Text Input and Find/Replace. Seems to have worked... is this correct position? 

framadan
5 - Atom

  

Pamelasdb1215
5 - Atom

Thank you - love this one

Xdejesus
5 - Atom

Interesting.

sanyamjain
5 - Atom

Quite good, i am a noob just starting out.

Omotayo
5 - Atom

Hi everyone,

i don't know what and how to go about this Text Input.yxzp 

Can someone please help me?

TNeedle
5 - Atom

It seems like the end of the street address, for example 'Drive', is being found and replaced with 'Drive$'. Am I reading that right? How does it then delimit the rest of the address by City, State, and Zip? It looked like Delimit is just the column name for the replace-with column, but is it also understanding that delimiting needs to be performed? Thanks for any help here.

BrianR
Alteryx
Alteryx

@TNeedle, correct - the Find Replace alters the Address Text field. Where the parsing happens is in the Formula tool. You will see fields for City Temp, Address, Zip, City, and State. Some of these formulas are simply parsing based on the location of that $ character...others are using some String functions (trim, right, substring, etc) to isolate a given part of the field.

mjsnyder
7 - Meteor

The visible images gives a great description.

RaphaelC
5 - Atom

I have a suggestion to update the sample, add a Select tool before Find Replace tool to expand size of [Address Text] field or first row result will be truncated, and zip will lose 1 character

Yaster99
5 - Atom

Na real added value the text is very simple

simran_singh
5 - Atom

good

emerymelvin3
6 - Meteoroid

I love the re-cap this article gave!

Lpsandre
5 - Atom

On the "Find and replace specific targets in your data " the first address missed "2" under the Zip field as well as  drop the E from ME after the Delimit is set.

Suyash11
6 - Meteoroid

another way to write expression to find City in Formula tool 

 

if

tonumber(Substring([Address Text] ,Length([Address Text])-5,5))!= 0 then left(trim(Substring([Address Text],FindString([Address Text], "$") + 1,100)),length(right([Address Text],
length(trim(Substring([Address Text],FindString([Address Text], "$") + 1,100)))))-9) else
left(trim(Substring([Address Text],FindString([Address Text], "$") + 1,100)),length(right([Address Text],
length(trim(Substring([Address Text],FindString([Address Text], "$") + 1,100)))))-3)
Endif

mvtejano
7 - Meteor

Interesting and very helpful. Thank you.

nithya_0406
5 - Atom

INTERSTING AND USEFULL

 

Gayitri420
7 - Meteor

Interesting.

Anitha1289
7 - Meteor

Thank you - love this one

Shyam_amarapu_2002
7 - Meteor

5-atom

Phaphani
5 - Atom

Brilliant

GuthurthiRaju
6 - Meteoroid

nice

nadiralam
7 - Meteor

okkk

 

Mohitku123
6 - Meteoroid

Intresting and helpful content to learn.

PrajwalShette
5 - Atom
okk
Mgaurav2grt
7 - Meteor

awesome 

Mgaurav2grt
7 - Meteor

best

pavaniadapa
5 - Atom

best

tomhollerbach
5 - Atom

Nice!

rfpinto
5 - Atom

clear and concise