Dynamic Select Tool

The Dynamic Select tool allows fields to be selected (or de-selected) either by field type or via a formula. Additionally dynamic or unknown fields will also be selected by field type or via formula at runtime.

It is very easy to end up with a stream with no fields.  Most tools can't handle that and it will cause an error.  The Transpose tool is among the few tools that can handle having no fields on input.

Look at the Data Statistics App \Program Files\Alteryx\RuntimeData\Analytic_Apps\DataStatistics.yxwz for a good example of usage.

Configuration Properties

Choose the mode for field selection. There are 2 modes for selection: