Study guide

2.2 Text Input & Directory Tools

Alteryx Designer Core Certification Exam

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Exam Overview, Designer Interface & Optimization

1.1 Exam Overview, Format & Strategy 1.2 Designer Interface, Canvas & Navigation 1.3 Alteryx Native File Formats & Workflow Packaging 1.4 Workflow Optimization, Caching & Performance

2 Chapter 2: In/Out Tools & Data Inspection

2.1 Input Data Tool Configuration & Formats 2.2 Text Input & Directory Tools 2.3 Output Data Tool Configuration & Options 2.4 Browse Tool & Data Profiling

3 Chapter 3: Core Preparation Tools & Data Types

3.1 Alteryx Data Types & Conversion Rules 3.2 Select Tool Configuration & Unknown Fields 3.3 Filter Tool & True/False Anchors 3.4 Data Cleansing Tool

4 Chapter 4: Advanced Preparation & Record Sampling

4.1 Formula Tool: Syntax, Operators & Conditional Logic 4.2 Formula Tool: Date/Time Functions & Type Casting 4.3 Sort Tool & Dictionary Sorting 4.4 Sample, Select Records & Unique Tools

5 Chapter 5: Blending Data: Join, Union & Append

5.1 Join Tool & Anchor Mechanics 5.2 Union Tool & Output Configurations 5.3 Find Replace Tool: Lookup & Text Substitution 5.4 Append Fields Tool & Cartesian Joins

6 Chapter 6: Parsing Data: Text, Dates & Regular Expressions

6.1 Text to Columns Tool 6.2 DateTime Tool 6.3 RegEx Tool: Methods & Syntax

7 Chapter 7: Transforming Data & Workflow Documentation

7.1 Summarize Tool & Aggregation Functions 7.2 Transpose Tool: Pivoting Wide to Long 7.3 Cross Tab Tool: Pivoting Long to Wide 7.4 Documentation Tools & Workflow Best Practices

8 Chapter 8: Practical Exam Scenarios & Troubleshooting

8.1 Troubleshooting Common Workflow Errors & Data Truncation 8.2 Practical Exam Question Walkthroughs & Modeling 8.3 Comprehensive Exam Strategy & Core Review

2.2 Text Input & Directory Tools

Key Takeaways Explain This Topic AI

The Text Input tool allows manual creation of static data tables directly on the workflow canvas without any external file or database dependencies.

Text Input data is embedded directly into the workflow's XML (.yxmd), ensuring 100% portability when sharing workflows across machines or servers.

The Text Input tool automatically infers data types and sizes string columns to the exact character length of the longest value entered in each column.

The Directory tool scans a file system path and outputs a standardized dataset of file metadata, including FullPath, Directory, FileName, CreationTime, LastWriteTime, and SizeBytes.

Combining the Directory tool with a Sort tool (LastWriteTime Descending) and Sample tool (First 1) is the standard pattern for dynamically grabbing the latest file in a directory.

Last updated: August 2026

2.2 Text Input & Directory Tools

Core Certification Focus: Understand when to use Text Input versus external files, how Text Input auto-assigns data types and string lengths, and the exact metadata fields generated by the Directory tool (especially FullPath , FileName , CreationTime , LastWriteTime , and SizeBytes ).

1. Text Input Tool Architecture & Capabilities

The Text Input tool (In/Out palette) allows you to manually type or paste small datasets directly onto the canvas. It requires no external connection, making it ideal for self-contained workflows.

Primary Use Cases

Lookup & Mapping Tables: Creating static reference tables (e.g., State Code → State Name, Department ID → Department Head) for Join or Find Replace tools.

Testing & Prototyping: Providing isolated test data to validate complex Formula expressions or RegEx parsing logic without relying on massive production files.

Dynamic Configuration Streams: Supplying control parameters or file paths into iterative macros and Dynamic Input tools. +-----------------------------------------------------------------------------+

  • | TEXT INPUT TOOL ON CANVAS |
  • | |
  • | (No Input) ---> [ Text Input ] ---> (1 Output Anchor: Output Data)|
  • | (Green) |
  • +-----------------------------------------------------------------------------+
  • 2. Text Input Data Entry & Type Inference

You can populate a Text Input tool by:

Direct Cell Entry: Clicking into cells to type values, using Tab to navigate columns and Enter to create new rows.

Copy / Paste: Copying cell ranges from Microsoft Excel, Google Sheets, or delimited text and pressing Ctrl + V inside the Text Input configuration window.

Context Menu Operations: Right-clicking cells to Insert Row , Delete Row , Insert Column , or Delete Column . +-----------------------------------------------------------------------------+

  • | TEXT INPUT CONFIGURATION WINDOW |
  • +-----------------------------------------------------------------------------+
  • | | Region_ID | Region_Name | Target_Sales | Active | Launch_Date |
  • |----+-----------+--------------+--------------+--------+---------------------|
  • | 1 | 101 | Northeast | 500000.00 | True | 2026-01-15 |
  • | 2 | 102 | Southeast | 450000.00 | True | 2026-02-01 |
  • | 3 | 103 | Midwest | 380000.00 | False | 2026-03-10 |
  • | 4 | 104 | West | 620000.00 | True | 2026-04-05 |
  • +-----------------------------------------------------------------------------+
  • Automatic Type Inference Rules & Traps

When you run a workflow, Alteryx examines the data entered in the Text Input tool and automatically assigns field types:

Whole Numbers: Assigned as Byte , Int16 , Int32 , or Int64 depending on magnitude.

Decimal Numbers: Assigned as Double or FixedDecimal .

Booleans: Text entries of True or False are inferred as Bool .

Dates: Strings formatted strictly as yyyy-mm-dd are inferred as Date .

Strings: Inferred as String or V_String .

Warning

Critical Exam Trap: Exact String Auto-Sizing The Text Input tool sets the byte size of a String column to the exact length of the longest value in that column at configuration time . In the table above, the longest Region_Name is "Northeast" (9 characters). Alteryx assigns Region_Name a type of String with size 9 . If you later join or union this stream with external data containing "Pacific Northwest" (17 characters), the downstream data will be truncated to 9 characters unless you insert a Select Tool to increase the field size!

3. Directory Tool Overview & Configuration

The Directory tool (In/Out palette) scans a specified directory on a local or network file system and returns a list of all matching files along with their file system metadata. +-----------------------------------------------------------------------------+

  • | DIRECTORY TOOL CONFIGURATION |
  • +-----------------------------------------------------------------------------+
  • | Directory: [ C:\EnterpriseData\FinancialReports\ ] |
  • | File Specification: [ Monthly_*.xlsx ] |
  • | [X] Include SubDirectories |
  • +-----------------------------------------------------------------------------+
  • Configuration Options

Directory: The folder path to search (e.g., C:\EnterpriseData\FinancialReports\ ).

File Specification (Filter): Wildcard pattern defining which files to return. Defaults to *.* (all files). Examples:

*.csv → Returns all CSV files.

Sales_202?.xlsx → Returns Excel files matching specific single-character years.

Include SubDirectories: When checked, recursively searches all subfolders within the target directory.

4. Directory Tool Output Schema Deep Dive

The Directory tool outputs a standardized tabular schema containing 10+ metadata fields for every matching file found:

Output Field Name Data Type Description & Example Content

FullPath V_WString Complete absolute path including drive, directories, filename, and extension.; (e.g., C:\Data\Reports\Q1_Sales.xlsx )

  • Directory V_WString Path of the containing folder without the filename.; (e.g., C:\Data\Reports\ )
  • FileName V_WString Filename and extension only.; (e.g., Q1_Sales.xlsx )
  • ShortFileName V_WString 8.3 DOS-compatible shortened filename.; (e.g., Q1_SAL~1.XLS )

CreationTime DateTime File creation timestamp ( yyyy-mm-dd hh:mm:ss ).

LastWriteTime DateTime Last modified/saved timestamp ( yyyy-mm-dd hh:mm:ss ).

LastAccessTime DateTime Last accessed/opened timestamp.

SizeBytes Int64 File size on disk measured in bytes. (e.g., 1048576 for 1MB) .

AttributeArchive Bool True if Windows Archive flag is active.

AttributeReadOnly Bool True if file is marked read-only.

AttributeHidden Bool True if file is marked hidden.

AttributeSystem Bool True if designated as an operating system file.

5. Practical Design Pattern: Ingesting the Most Recent File

A classic scenario tested on the Core exam is dynamically identifying and processing the single most recently updated file in a folder.

Step-by-Step Tool Pipeline:

Directory Tool: Set Directory to C:\Incoming\ and File Specification to *.csv .

Sort Tool: Sort LastWriteTime in Descending order (places newest file at Row 1).

Sample Tool: Select First 1 Records (isolates the latest file).

Dynamic Input Tool (or Macro): Reads the FullPath field to load the file contents. +-------------+ +-------------+ +-------------+ +-----------------+

  • | Directory | ---> | Sort | ---> | Sample | ---> | Dynamic Input |
  • | (*.csv) | | (LastWrite | | (First 1) | | (Reads FullPath)|
  • | | | Descending)| | | | |
  • +-------------+ +-------------+ +-------------+ +-----------------+
  • 6. Summary Comparison: Text Input vs. Input Data vs. Directory
  • Feature Text Input Tool Input Data Tool Directory Tool
  • Data Origin Workflow XML ( .yxmd ) External File or DB File System Metadata
  • Portability 100% portable (Self-contained) Requires external file access Scans local/network paths
  • Dynamic Changes Static; requires manual edit Updates when source file updates Updates when directory changes
  • Primary Output Tabular user data Tabular source data File metadata (paths, sizes, dates)

Loading diagram... Automated Latest-File Processing Architecture