Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesAdditional Dynamic Select Mode for All Native (Non-Macro) Tools with Select Functionality (with or without Data Type Selection)
This is the updated version of an idea I posted a while ago (which only included Multi-Field Formula), and after the release of Alteryx Designer 2025.1, which I found to be very successful from a new tool and functionality perspective, I decided to post about it.
My proposition is to add the Dynamic Select functionality* (at least the Select via a Formula mode) to all native (non-macro) tools in all tool categories that include a Select functionality (as an alternative, where the user would be OK with not being able to also change the field types of the selected fields, such as Join and Append tools, the opposite would apply to Multi-Field Formula, where the user would be able to dynamically select which fields the Multi-Field Formula would be applied to, in addition to changing the data type), including but not limited to (to account for any new tool with a Select functionality that might be added in the future):
Preparation Category
- Auto Field
- Data Cleanse Pro (added in 2025.1)
- Multi-Field Formula
- Multi-Row Formula (for Group By option)
- Rank (for Group By option)
- Record ID (for Group By option)
- Sample (for Group By option)
- Tile (for Group By option)
- Unique
Join Category
- Append Fields
- Find Replace
- Join
- Join Multiple
Transform Category
- Arrange
- Cross Tab
- Make Columns (for Grouping Fields (Optional) option)
- Running Total (for both Group By (Optional) and Create Running Total options)
- Transpose (for both Key Columns and Data Columns options, the tool would generate an error if the Dynamic Select formula written for both options are selecting the same field(s), as the Transpose tool is not supposed to allow it)
- Weighted Average (for Grouping Fields (Optional) option)
In-Database Category
- Select In-DB
Reporting Category
- Layout (for Group By and Per Column Configuration options)
- Table (for Group By and Per Column Configuration options)
Machine Learning Category
- Transformation (for Select Features mode only, as the other two modes with Select functionality (Clean Up Missing Values and One Hot Encoding) require Method and Missing Category Action specification)
Developer Category
- Download (for And values from these fields option present in Headers and Payload tabs)
- Dynamic Rename (for the Select functionality present in Formula mode)
Spatial Category
- Find Nearest
- Spatial Info
- Spatial Match
Data Investigation Category
- Pearson Correlation
Skipping Address and Demographic Analysis categories as they have tools that seem to be using a static input, therefore not requiring a Dynamic Select functionality.
Laboratory Category
- JSON Build (for Grouping Fields (Optional) option)
- Transpose In-DB (with a similar logic to the regular Transpose tool found in Transform category)
*The Dynamic Select functionality added tools that have more than one input anchor (such as Join and Join Multiple) could have new additional fields the users can utilize, such as:
- [Origin] (can have the values "L" or "R" for Join and Append tools)
- [Connection_ID] (can have the values 1, 2, 3 etc. for Join Multiple tool)
- [Unknown] (can have the values "True" or "False" for the Data Columns option of the Transpose tool, or any other tools such as Join that would have the Dynamic or Unknown Columns option as a part of their Select functionality)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.