Check out this content on our new Help site.
Tool Use with AMP
For information on how the original engine and AMP impact a workflow, see: Alteryx Engine and AMP: Main Differences .
Fully-Converted Tools
Tool | Difference between the original engine and AMP |
Action | |
Append Fields | |
Arrange | |
AutoField | Data types might differ. |
Basic Data Profile | |
Blob Input | |
Block Until Done | Paralled Block Until Done from CReW Macro pack doesn't work with AMP. |
Browse | |
Browse Everywhere | |
Check Box | |
Comment | |
Condition | |
Control Parameter | |
Count Records | |
Create Points | |
Cross Tab | Record order. You can fix this with Engine Compatibility Mode. |
Data Cleansing | Original Engine removes "©" as a punctuation mark and reorders records when removing null rows without Engine Compability Mode turned on. |
Date | |
Date Time Now | |
DateTime | |
Detour | |
Detour End | |
Directory | |
Download | |
Drop Down | |
Dynamic Input | |
Dynamic Rename | |
Dynamic Replace | |
Dynamic Select | |
Error Message | |
Expect Equal | With the original Engine it's macro. With AMP, Expect Equal is a native tool. |
Field Info | |
File Browse | |
Filter | |
Find Replace | |
Fuzzy Match | Record order/column order. Records are matched in a different order with AMP. |
Generate Rows | |
Image | |
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. There is a maximum of 32 allowed connections for this tool when AMP is enabled. This is to prevent deadlocks. |
JSON Parse | |
Layout | |
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. While AMP engine writes SpatialObj data into the file when saving as a CSV, the original Engine doesn't. This causes a file size difference and a performance issue. |
Overlay | |
Oversample Field | |
Pearson Correlation | |
Poly-Build | Record order. Due to the different method of grouping with AMP, the output order is different. |
Radio Button | |
Random % Sample | Deterministic output mode selects different records with AMP. |
RecordID | |
RegEx | |
Render | |
Report Text | |
Run Command | |
Running Total | Record order. Due to the different method of grouping with AMP, the output order is different. |
Sample | Group by column mode outputs records in a different order. |
Select | |
Select Records | |
Sort | Based on sort parameters. |
Spatial Info | |
Spatial Match | In mode "Use records from File or Database" only CSV, YXDB, and SQLite formats have been converted. Other file formats use the original Engine. |
Table | |
Test | With AMP, this tool outputs the error "Error: Test (109): No tests are configured for input #2" if there are no tests for specific connection. |
Text Box | |
Text Input | AMP creates the maximum size field for strings and integers so that subsequent operations 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. There is a maximum of 32 allowed connections for this tool when AMP is enabled. This is to prevent deadlocks. |
Unique | Record order and output result (different records). Due to the different method of grouping with AMP, the output order is different. |
Weighted Average | When Grouping Fields mode is used, AMP outputs records in a different order. |
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 such scenario. |
Create Samples | Summarize tool is partially converted. Formula tool is missing custom formula functions/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 | Record order. Can be fixed with Engine Compatibility Mode. Due to a different method of grouping with AMP, the output order is different. |
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 Group By. Actions not supported in AMP include Report\Combine Horizontal, Report\Combine Vertical, Spatial\Combine, 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. |