Tool Use with AMP

Version:

Current

Last modified: February 11, 2021

For information on how the original engine and AMP impact a workflow, see: Alteryx Engine and AMP: Main Differences.

Fully-Converted Tools

Tools that have been converted from the original engine to AMP.

Tool	Difference between the original engine and AMP
Action
Append Fields
Arrange
AutoField
Basic Data Profile
Blob Input
Block Until Done
Browse
Browse Everywhere	Record order. For performance reasons, this tool could provide different output, run-to-run, because it doesn't require sequence, and can take any record packet that comes from a tool.
Checkbox
Comment
Condition
Control Parameter
Count Records
Create Points
Cross Tab	Record order
Data Cleansing
Date
Date Time Now
DateTime
Detour
Detour End
Directory
Download	Only UTF8 encoding is supported.
Drop Down
Dynamic Input	Record order. The original engine sorts the input records to filter out duplicates. AMP filters out duplicates without sorting.
Dynamic Rename
Dynamic Replace
Dynamic Select
Error Message
Expect Equal	With the original engine it's a macro, with AMP the Expect Equal is a native tool.
Field Info
File Browse
Filter
Find Replace
Folder Browse
Fuzzy Match	Record order/column order. Records are matched in a different order with AMP.
Generate Rows
Input Data	Only XLSX, CSV, YXDB, and SQLite formats have been converted. All other formats will fall back to original Engine.
Join	Record order. Due to the different method of grouping with AMP, the output order is different.
Join Multiple	Record order. Due to the different method of grouping with AMP, the output order is different.
JSON Parse
List Box
Macro Input
Macro Output
Make Group
Map
Message
Multi-Field Binning
Numeric Up Down
Output Data	Only XLSX, CSV, YXDB, and SQLite formats have been converted. All other formats will fall back to original Engine.
Pearson Correlation
Poly-Build	Record order. Due to the different method of grouping with AMP, the output order is different.
Radio Button
Random%Sample
Record ID
RegEx
Run Command
Running Total	Record order. Due to the different method of grouping with AMP, the output order is different.
Sample
Select
Select Records
Sort
Spatial Info
Spatial Match	In mode "Use records from File or Database" only CSV, YXDB and SQLite formats have been converted. Other file formats will use the original Engine.
Test
Text Box
Text Input	AMP creates the maximum size field for strings and integers so that subsequent operations will have the necessary room to hold larger downstream values, whereas the original engine creates the minimum size required to accommodate the data.
Text To Columns
Throttle	Not available on AMP, but you can use it together with the Download tool (Throttle first).
Tile	Record order. Due to the different method of grouping with AMP, the output order is different.
Tool Container
Transpose
Tree
Union	Record order. The order of the records may differ due to their variable processing. You can avoid this by setting a specific output order.
Unique	Record order and output result (different records). Due to the different method of grouping with AMP, the output order is different.
Weighted Average
XML Parse

Partially-Converted Tools

Tools where not all functionality or configuration has been converted from the original engine to AMP. The functionality of all partially-converted tools is retained on AMP, with fall-back to the original engine when needed.

Tool	Difference between the original engine and AMP
Blob Convert	With AMP, the conversion to a Blob from Text Data and vice versa is not supported. Falls back to the original engine in this scenario.
Create Samples	Summarize tool is partially converted. Formula tool is missing custom expressions/add-ins.
Distance	Falls back to the original engine for drive time support and distance to destination.
Find Nearest	AMP does not support drive time/distance, so it falls back to original engine for those operations.
Formula	Custom saved expressions are not available on AMP.
Heat Map	Summarize tool is partially converted.
Imputation
Multi Field Formula	Custom saved expressions are not available on AMP.
Multi Row Formula	Custom saved expressions are not available on AMP.
Summarize	Different order for actions which use grouping. Actions not supported in AMP, including Report\Combine Horizontal, Report\Combine Vertical and Behavior Analysis\Combine profiles. Falls back to the original engine when used.
Trade Area	Falls back to the original engine for drive time support.