Study guide
3.2 Select Tool Configuration & Unknown Fields
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
3.2 Select Tool Configuration & Unknown Fields
Key Takeaways Explain This Topic AI
The Select tool is the foundational schema management utility in Alteryx, enabling column selection/deselection, field renaming, data type casting, string length adjustment, and column reordering.
The dynamic *Unknown field row dictates how newly discovered or unmapped upstream fields are handled: leaving it checked passes new fields through downstream, while unchecking it drops unexpected columns.
The vertical position of the *Unknown row defines where newly introduced upstream columns appear in the data stream relative to existing configured columns.
The Options dropdown menu provides powerful bulk maintenance utilities, including bulk prefix/suffix application, alphabetical sorting, field configuration save/load (.yxft), and the 'Forget Missing Fields' command to remove stale metadata warnings.
Embedded Select configuration windows exist directly inside the Join, Append Fields, Find Replace, and Spatial Match tools, allowing in-line schema manipulation without adding standalone Select tools.
Last updated: August 2026
3.2 Select Tool Configuration & Unknown Fields
Core Concept: The Select tool is the primary schema modification instrument in Alteryx Designer. Positioned in the Preparation tool palette, it allows analysts to control column inclusion, rename fields for business clarity, change data types and storage allocations, reorder field sequences, and dynamically govern incoming upstream schema changes via the *Unknown field handler.
1. Select Tool Configuration Window Architecture
The Select tool configuration window presents a structured grid displaying all columns present in the incoming data stream. Each row corresponds to a specific field, along with a special dynamic row at the bottom labeled *Unknown . ┌───────────────────────────────────────────────────────────────────────────────────────┐
- │ Select Configuration Window Grid │
- ├─────┬──────────────────┬──────────────────────┬─────────────┬─────────┬───────────────┤
- │ [✓] │ Field │ Rename │ Type │ Size │ Description │
- ├─────┼──────────────────┼──────────────────────┼─────────────┼─────────┼───────────────┤
- │ [✓] │ Cust_ID │ Customer_ID │ Int32 │ 4 │ Primary Key │
- │ [✓] │ First_Nm │ First_Name │ V_WString │ 100 │ Given Name │
- │ [✓] │ Last_Nm │ Last_Name │ V_WString │ 100 │ Family Name │
- │ [ ] │ Temp_Flag │ │ Byte │ 1 │ Exclude Field │
- │ [✓] │ Trans_Amt │ Transaction_Amount │ FixedDecimal│ 19.2 │ Ledger Amount │
- │ [✓] │ *Unknown │ │ │ │ Dynamic Field │
- └─────┴──────────────────┴──────────────────────┴─────────────┴─────────┴───────────────┘
- Grid Columns and Their Functions
Include Checkbox [✓] : Determines whether the field passes through to downstream tools. Unchecking a box drops the field from the data stream, freeing memory and streamlining downstream processing.
Field : Displays the original incoming field name as received from the upstream tool. This name cannot be edited directly in this column.
Rename : Allows entering a new alias for the field. Downstream tools will reference this new name. Downstream formulas and joins will immediately recognize the renamed identifier.
Type : A dropdown selector to change the field's data type (e.g., converting a text V_String containing numbers into Double or Int32 ).
Size : Specifies the byte allocation for fixed string types ( String , WString ), maximum length for variable strings ( V_String , V_WString ), or precision and scale for FixedDecimal (e.g., 19.2 ). For fixed-width numeric types ( Int16 , Int32 , Double ), this field is read-only.
Description : An optional metadata documentation field. Text entered here does not alter data but attaches metadata annotations visible in downstream tools and documentation exports.
2. Field Reordering and Performance Optimization
Field order in Alteryx is not purely aesthetic; it defines the structural index of columns in downstream outputs, reports, and flat file exports.
Reordering Mechanics
To reorder fields within the Select tool:
Move Up / Move Down : Select one or more field rows and click the ▲ Move Up or ▼ Move Down buttons at the top of the configuration window.
Bulk Movement : You can highlight multiple contiguous or non-contiguous rows (using Shift-Click or Ctrl-Click) and move them collectively.
Sorting via Options Menu : Sort fields alphabetically by name or by data type in ascending or descending order.
Workflow Optimization via Column Pruning
One of the most effective workflow optimization practices in Alteryx is early column pruning . Dropping unneeded fields using a Select tool immediately after an Input Data tool drastically reduces memory usage, minimizes disk caching during sort/join operations, and accelerates engine throughput.
3. The *Unknown Dynamic Field Handler (Deep Dive)
The *Unknown entry (often called the dynamic field handler) is a permanent structural element located in every Select tool configuration grid. It dictates how Designer behaves when upstream data sources change dynamically. Upstream Schema Modification
- (e.g., 2 New Columns Added to Raw Source)
- │
- ▼
- ┌───────────────────────────┐
- │ Select Tool Configuration │
- └─────────────┬─────────────┘
- │
- ┌───────────────────────┴───────────────────────┐
- ▼ ▼
- [*Unknown] CHECKED [*Unknown] UNCHECKED
- ┌─────────────────────────────┐ ┌─────────────────────────────┐
- │ Dynamic Pass-Through: │ │ Strict Schema Enforcement: │
- │ • New columns pass through │ │ • New columns are dropped │
- │ • Retain original names │ │ • Only explicit fields pass │
- │ • Positioned at *Unknown row│ │ • Protects downstream schema│
- └─────────────────────────────┘ └─────────────────────────────┘
- Scenario 1: *Unknown is Checked [✓] (Default Behavior)
When upstream data introduces new columns that were not present when the workflow was authored (e.g., an updated monthly Excel file with new columns Region_Code and Manager ), these columns automatically pass through the Select tool.
The new columns appear in downstream tools with their incoming names and auto-detected data types.
Positioning : The new fields appear in the output stream at the exact vertical location where *Unknown is positioned in the Select grid.
Scenario 2: *Unknown is Unchecked [ ] (Strict Schema Enforcement)
Any incoming field that is not explicitly defined and checked in the Select configuration grid is silently dropped from the stream.
This setting is crucial in production ETL pipelines to enforce strict schema governance and prevent unexpected upstream column additions from breaking downstream tools.
Positioning the *Unknown Row
By default, *Unknown is at the bottom of the grid, meaning new fields appear on the far right of the dataset. However, you can move *Unknown up into any position:
If *Unknown is moved to the very top of the grid, all newly discovered upstream columns will appear as the first columns (far left) in the output data stream.
If *Unknown is placed between Customer_ID and First_Name , any newly added fields will be inserted between those two specific columns.
4. The Options Dropdown Menu & Bulk Actions
The Options button at the top of the Select configuration window provides powerful administrative utilities: ┌─────────────────────────────────────────────────────────────┐
- │ Select Options Menu Hierarchy │
- ├─────────────────────────────────────────────────────────────┤
- │ • Select / Deselect All ──► Check or uncheck all rows │
- │ • Invert Selection ──► Flips checked/unchecked │
- │ • Sort ──► Name / Type (Asc / Desc) │
- │ • Move ──► Move to Top / Bottom │
- │ • Add / Remove Prefix/Suffix ──► Bulk text manipulation │
- │ • Forget Missing Fields ──► Clear deleted column refs │
- │ • Save / Load Configuration ──► Export/Import .yxft schema│
- └─────────────────────────────────────────────────────────────┘
- 1. Bulk Selection
Select All / Deselect All : Instantly checks or unchecks all field checkboxes.
Invert Selection : Reverses the selection state of every field in the list.
2. Bulk Renaming (Prefix / Suffix)
Add Prefix to Field Names : Prepends a text string to all highlighted fields (e.g., adding SourceA_ to 20 columns simultaneously).
Add Suffix to Field Names : Appends a text string to all highlighted fields (e.g., adding _2026 ).
Remove Prefix / Suffix : Strips specified leading or trailing strings in bulk.
3. Forget Missing Fields (High-Yield Exam Concept)
When upstream columns are removed or renamed, the downstream Select tool continues to remember the former fields, displaying them highlighted in yellow with a missing field warning. Clicking Options → \rightarrow → Forget Missing Fields permanently purges these ghost fields from the configuration grid.
4. Save and Load Field Configuration ( .yxft )
Save Field Configuration : Exports the entire schema definition (field names, types, sizes, order, and renames) to an external XML-based .yxft (Alteryx Field Type) file.
Load Field Configuration : Imports a saved .yxft schema file into any Select tool, ensuring uniform column naming and data types across enterprise pipelines.
5. Embedded Select Functionality in Other Tools
To streamline workflows and eliminate tool clutter, Alteryx embeds the full Select configuration grid inside several core data blending and spatial tools:
Join Tool : Contains embedded Select windows for Left ( L ), Join ( J ), and Right ( R ) streams, allowing immediate renaming and field dropping during the join.
Append Fields Tool : Allows schema modifications when combining cartesian records.
Find Replace Tool : Allows selecting which fields from the Replace ( R ) table are appended.
Spatial Match Tool : Allows schema modifications during spatial intersections.
Exam Tip: If a workflow requires renaming fields immediately after a Join, you do not need to add a separate Select tool. Perform the renaming directly within the Join tool's embedded Select grid!