Dynamic Select Tool Icon

Dynamic Select Tool

Version:
Current
Last modified: June 11, 2020

Use Dynamic Select to select (or de-select) fields either by field type or via a formula. Additionally, dynamic or unknown fields are also selected by field type or via formula at runtime. This tool requires an input.

Look at the Data Statistics App C:\Program Files\Alteryx\bin\RuntimeData\Analytic_Apps for a good usage example.

Configure the Tool

Choose the mode for field selection:

  • Select Field Types: Fields are selected based on their field type. Check the box to the left of the field types to add to your selection.
  • Select via a Formula: Fields are selected based on criteria specified via the formula processor.

Use the Formula Processor to construct the expression that results in field selection. To select fields containing ID:

FINDSTRING([Name], "ID")>-1

The following field information data fields are available for building the expression:

Boolean value tests for a string data type - String, V_String, WString, V_WString.

  • Name: Field names within the data stream
  • Type: Type of data field
  • Size: Length of the data field
  • Scale: With respect to Fixed Decimal data types, scale refers to the digits of precision.
  • Source: Contains the tool or the file the field came from. Might also contain additional Metainfo such as a specific dataset from a plugin. The tools that report metainfo include the Allocate Input, Allocate Append, CASS, and Street Geocoder, and tools that calculate drivetime, like Trade Area, Distance, and Find Nearest.
  • Description: Might not contain information. If data is appended from Allocate for example, the descriptive longer field name is contained here. Additionally, the user can add their own field description via the Select tool and the information stays associated with the field.
  • IsNumeric: Boolean value tests for a number data type: Integer, fixed decimal, float, double, etc.
  • IsFloat: Boolean value tests for a float data type.
  • IsInteger: Boolean value tests for an Integer data type.
  • IsStringOrDate: Boolean value tests for any string or any Date data type.
  • IsDateOrTime: Boolean value tests for any Date or Time data type.
  • IsDate: Boolean value tests for any Date data type.
  • IsBinary: Boolean value tests for a Binary data type.
  • IsSpatialObj: Boolean value tests for a Spatial data type.
  • FieldNumber: Field number position.

Data fields appear in this order: A, B, C. FieldNumber==1 returns Field A.

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.