Text Input Tool
User Role Requirements
User Role* | Tool/Feature Access |
|---|---|
Full User | ✓ |
Basic User | ✓ |
*Applies to Alteryx One Professional and Enterprise Edition customers on Designer versions 2025.1+.
Use Text Input to manually enter text to create small data files for input. You can also use this tool to test and create Lookup tables while you build your workflow.
The data input from the Text Input tool is saved within the workflow, so you can share the workflow without providing an input data file.
One Tool Example
This tool has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Designer.
Text Input and AMP
Text Input creates different data types depending on whether your workflow uses Alteryx Multi-threaded Processing (AMP) or the original Engine.
AMP: Text Input creates a V_String data type of maximum length (up to 2,147,483,647 characters).
Original Engine: Text Input creates a String data type with a length that matches the longest string entered via the Text Input tool.
Please note that while a V_String only consumes the necessary memory to store the data it contains when processing in Designer, we recommend that you use a Select tool or AutoField tool to set a more precise string length before you write to a database.
Additionally, when you use the Text Input tool, the AMP engine provides more reliable and explicit data typing than the original Engine.
Original Engine: Automatically converts certain letter values like "F" and "T" into Boolean False and True. This can lead to unexpected type conversions when you enter single-character strings.
AMP: Doesn't auto-convert "F" or "T" to Boolean. These values are preserved as String unless clearly defined as Boolean. This avoids unintended type changes and offers more predictable behavior.
To keep the values you enter as strings without type detection on either engine, turn off automatic column detection. Go to Disable Automatic Column Detection.
Configure the Tool
Select cells to enter data values. By default, the tool autoconfigures data types based on the values you enter. To keep your values exactly as entered, turn off automatic field detection. Go to Disable Automatic Column Detection.
To rename Field Names, select a header cell and enter a new header name.
Options Menu
Within the Configuration window, you can perform several actions via the Options toolbar. Options include...
Import: Browse for an existing data file or connection. The Text Input tool is limited to 10,000 total cells on import, but you can manually add more cells if needed.
Copy: Copy selected values onto the clipboard.
Paste: Paste values from the clipboard into a cell.
Delete: Options include...
All: Deletes all the data in the grid.
Rows: Deletes the current, selected rows.
Columns: Deletes the current, selected columns.
Header: Deletes the entire header row.
Insert: Options include Row, Column, and Header insertion.
Any blank cells result in NULL values.
Navigate Cells via Keyboard
The Tab key moves the cursor into cells from Left to Right.
Shift+Tab moves the cursor into cells from Right to Left.
Up and Down Arrow keys move the cursor into cells from row to row.
For information regarding Input, Output, Annotation, and Error Properties, visit Tool Configuration.
Disable Automatic Column Detection
Important
Automatic Column Detection is on by default, and workflows saved before this option existed (before 2026.4) keep their current behavior.
This option works with both the original engine and the AMP engine.
By default, the Text Input tool detects field types and sizes from the values you enter. Turn off automatic field detection to output your values as strings instead. The tool doesn't determine field types or shorten field sizes in your data. Turn off automatic field detection when you need to:
Keep leading zeros in identifiers, such as 00123.
Keep large numbers that look like numeric values.
Keep date-like text as entered.
Get predictable output field types and sizes.
To turn off automatic column detection, follow these steps:
Select the Text Input tool.
In the Configuration window, select the Disable Automatic Column Detection checkbox.
When the automatic column detection is off:
Values are output as strings. Use a Select tool or Auto Field tool later in your workflow to set the column types you need.
Column names, column order, and the way blank cells become NULL values don't change.
The option is saved with the tool configuration.
