Study guide
2.1 Input Data Tool Configuration & Formats
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.1 Input Data Tool Configuration & Formats
Key Takeaways Explain This Topic AI
The Input Data tool connects to flat files (CSV/TXT), Excel workbooks, native .yxdb files, relational databases (SQL Server/Oracle/Postgres), and semi-structured XML/JSON sources.
Setting a Record Limit (e.g., 100) reads only the first N sequential rows at ingestion time, significantly accelerating workflow testing and development.
Wildcard characters (* and ?) enable single-tool multi-file ingestion (e.g., Sales_202*.csv or *.xlsx|||Sheet1), strictly requiring identical schemas across all matched files.
The Output File Name as Field configuration appends 'File Name Only' or 'Full Path' as a new column at the far right of the incoming dataset.
The Input Data tool is a starting tool that has exactly 0 input anchors and 1 output anchor.
Last updated: August 2026
2.1 Input Data Tool Configuration & Formats
Core Certification Focus: The Input Data tool is tested extensively on the Core exam. You must know its supported file types, how configuration options (like Record Limit and Delimiters) alter incoming data, how the "Output File Name as Field" option behaves, and the exact wildcard syntax for ingesting multiple files or Excel sheets simultaneously.
1. Tool Overview & Canvas Role
The Input Data tool (located in the green In/Out tool palette) brings external data into an Alteryx workflow. It connects to local files, network shares, spatial layers, relational databases, and cloud data warehouses.
Tool Anchor Mechanics
Input Anchors: 0 (It is a source tool; nothing connects into its left side).
Output Anchors: 1 (Labeled with output arrow 1 on the right side, passing records downstream). +-----------------------------------------------------------------------------+
- | INPUT DATA TOOL ANCHORS |
- | |
- | (No Input) ---> [ Input Data ] ---> (1 Output Anchor: Output Data) |
- | (Green) |
- +-----------------------------------------------------------------------------+
- 2. Supported File Formats & Performance
Alteryx Designer natively reads dozens of structured, semi-structured, and spatial formats. Understanding the operational differences between these formats is essential for exam success:
Format Category Extensions / Sources Key Characteristics & Exam Notes
Alteryx Database .yxdb Native Alteryx format. Uncompressed or spatial/lz4 compressed. Preserves exact field types and metadata. Fastest format to read/write with no file size limit. Preferred for intermediate staging.
Delimited Text .csv , .tsv , .txt , .dat Plain text files separated by commas, tabs, pipes ( | ), or custom characters. Requires delimiter and code page configuration. Default string field length is 254 bytes.
Spreadsheets .xlsx , .xls , .xlsm , .xlsb Microsoft Excel files. Requires specifying a sheet name (e.g., Sheet1$ ), a named range, or a cell range (e.g., Sheet1$A1:D50 ).
Relational Databases SQL Server, Oracle, PostgreSQL, MySQL, Snowflake Accessed via ODBC, OLEDB, or native Quick Connect drivers. Allows visual query building or direct SQL query execution.
Semi-Structured .xml , .json Parses hierarchical XML elements or JSON strings into tabular records and fields.
Spatial Files .shp , .kml , .tab , .geojson , .mif Contains vector geometries (Points, Lines, Polygons) alongside tabular attribute data.
Zip Archives .zip , .gz , .tar.gz Directly extracts and reads a single supported file format contained inside a compressed archive.
3. Configuration Window Properties & Settings
When you drag an Input Data tool onto the canvas, the Configuration window presents essential parameters that control how files are parsed: +-----------------------------------------------------------------------------+
- | INPUT DATA CONFIGURATION PANE |
- +-----------------------------------------------------------------------------+
- | 1. Connect a File or Database: [ C:\Data\Sales\Orders_2026.csv ] |
- | --------------------------------------------------------------------------- |
- | Configuration Properties: |
- | Line 1: Record Limit [ 100 ] |
- | Line 2: Search SubDirs [ [ ] ] |
- | Line 3: Output File Name as Field [ File Name Only v ] |
- | Line 4: Delimiters [ , ] |
- | Line 5: First Row Contains Field Names[ [X] ] |
- | Line 6: Start Data on Line [ 1 ] |
- | Line 7: Field Length [ 254 ] |
- | Line 8: Code Page [ ISO 8859-1 Latin I v ] |
- | Line 9: Treat Read Errors as Warnings [ [ ] ] |
- +-----------------------------------------------------------------------------+
- Detailed Property Breakdown
- 1. Record Limit
Function: Limits the number of records read from the source data stream during workflow execution.
Behavior: Reads only the first N sequential records (e.g., entering 100 reads rows 1 through 100).
Exam Note: Setting Record Limit to 0 reads 0 data records but still pulls the column names/metadata. Leaving it blank reads all records. It does not take a random sample; it reads top-down sequentially.
2. Output File Name as Field
Function: Appends the source file path information as a new column in the output data stream.
Options:
No (Default): No file name column is created.
File Name Only : Appends a column containing only the file name and extension (e.g., Orders_2026.csv ).
Full Path : Appends a column containing the complete folder path, file name, and sheet/table specifier (e.g., C:\Data\Sales\Orders_2026.csv ).
Column Placement: The newly generated field is automatically placed as the last column on the far right of the data table.
3. Delimiters
Function: Defines the character used to separate fields in delimited text files.
Common Values: Comma ( , ), Tab ( \t ), Pipe ( | ), Semicolon ( ; ), or \0 (No delimiter — reads the entire line as a single string field).
4. First Row Contains Field Names
Function: When checked (default), Alteryx treats row 1 of the file as column headers.
Unchecked Behavior: When unchecked, Alteryx assigns generic field names ( Field_1 , Field_2 , Field_3 , etc.) and treats row 1 as the first record of data.
5. Start Data on Line
Function: Specifies the line number where data records begin.
Use Case: Commonly used when raw CSV or text files contain metadata titles or blank lines in rows 1–3 before the actual table header begins.
6. Field Length (Flat Files)
Function: Defines the maximum character length for string fields in delimited files (default is 254 bytes).
Warning/Trap: If incoming text data in any cell exceeds this length, Alteryx issues a conversion warning and truncates the string to 254 characters unless this limit is manually increased in the configuration pane.
4. Multi-File Ingestion via Wildcards
A major capability of the Input Data tool is ingesting multiple files from a folder in a single step using standard wildcard characters.
Wildcard Characters
Asterisk ( * ): Matches zero or more characters.
Example: C:\Data\Sales_*.csv matches Sales_Q1.csv , Sales_2026.csv , and Sales_.csv .
Question Mark ( ? ): Matches exactly one single character.
Example: C:\Data\Sales_202?.csv matches Sales_2025.csv and Sales_2026.csv , but not Sales_2026_Final.csv .
Excel Sheet Wildcard Syntax
To read all matching Excel workbooks and sheets, Alteryx uses the triple-pipe delimiter ( ||| ):
C:\Reports\*.xlsx|||Sheet1 → Reads Sheet1 from all .xlsx files in C:\Reports\ .
C:\Reports\2026_Sales.xlsx|||* → Prompts Alteryx to list or process sheets.
C:\Reports\*.xlsx|||<List of Sheet Names> → Returns a table containing the names of all sheets across the matching workbooks rather than the record data.
The Golden Schema Rule for Wildcards
When using wildcards to read multiple files:
All matching files MUST have the exact same schema (identical column names and compatible data types).
If File 1 has columns [ID] , [Name] , [Sales] and File 2 has [ID] , [Customer] , [Sales] , Alteryx will issue a Schema Mismatch Warning .
By default, Alteryx will only read the columns that match the schema of the first file encountered , dropping or nulling unmatched fields in subsequent files.
5. Common Exam Traps & Best Practices
Warning
Exam Trap: Record Limit vs. Sample Tool A Record Limit set in the Input Data configuration stops reading data at the file reader level. It does not select a random distribution—it pulls the top N records sequentially. If you need a random 10% or the last 100 rows, do not use Record Limit; use the Sample Tool downstream.
Important
Exam Trap: 254-Byte String Truncation Flat files (CSV/TXT) default to a field length of 254 characters. If your data contains customer comments or long addresses exceeding 254 characters, Alteryx will silently truncate the data and log a warning in the Results window. You must increase the Field Length parameter (e.g., to 5000 or 10000 ) in the Input Data tool configuration.
Note
Exam Trap: Output File Name Placement Questions frequently ask where the file name field is located when "Output File Name as Field" is enabled. It is always appended as the last column on the far right , never inserted as the first column.