Tool Use with AMP

Version:

Current

Last modified: June 03, 2020

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
Append Fields
Arrange
AutoField
Basic Data Profile
Blob Input
Block Until Done
Browse
Browse Everywhere	Record order. For perfomance 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.
Create Points
Cross Tab	Record order
DateTime
Detour
Detour End
Directory
Dynamic Input	Record order. The original engine sorts the input records to filter out duplicates. AMP filters out duplicates without sorting.
Dynamic Rename
Dynamic Select
Expect Equal	With the original engine it's macro, with AMP the Expect Equal is a native tool.
FieldInfo
Filter
Find Replace
Fuzzy Match	Record order/column order. Records are matched in a different order with AMP.
Generate Rows
Input Data	Only 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
Make Group
Message
Output Data	Only CSV, YXDB and SQLite formats have been converted. All other formats will fall back to original Engine.
PearsonCorrelation
Poly-Build	Record order. Due to the different method of grouping with AMP, the output order is different.
RecordID
RegEx
Run Command
Running Total	Record order. Due to the different method of grouping with AMP, the output order is different.
Sample
Select
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 Input
TextToColumns
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.
Transpose
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.
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.
Distance	Falls back to the original engine for drive time support and distance to destination.
Download	Only UTF8 encoding is supported.
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.
MultiFieldFormula	Custom saved expressions are not available on AMP.
MultiRowFormula	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, Spatial\Combine, Spatial\Create Intersection, 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.