Tool Use with AMP
Version:
2022.1
Last modified: May 04, 2022
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 | Data types may differ. |
| Basic Data Profile | |
| Blob Input | |
| Block Until Done | Parallel BUD from Crew macro pack will not work with AMP. |
| Browse | |
| Browse Everywhere |
|
| Checkbox | |
| Comment | |
| Condition | |
| Control Parameter | |
| Count Records | |
| Create Points | |
| Cross Tab | Record order. Can be fixed with Engine Compatiblity 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 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 | |
| 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. There is a maximum of 32 allowed connections for this tool when AMP is enabled 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. |
| 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 will select different records with AMP. |
| Record ID | |
| 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 will output records in different order. |
| 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. |
| Table | |
| Test | With AMP this tool will output error “Error: Test (109): No tests are configured for input #2“ if there no tests for specific connection. |
| 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. There is a maximum of 32 allowed connections for this tool when AMP is enabled 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 used AMP will output 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 this 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 formula functions/add-ins are not available on AMP. |
| Heat Map | Summarize tool is partially converted. |
| Imputation | Record order. Can be fixed with Engine Compatiblity Mode. Due to the different method of grouping with AMP, the output order is different. |
| Multi Field Formula | Custom formula functions/add-ins are not available on AMP. |
| Multi Row Formula | Custom formula functions/add-ins are not available on AMP. |
| Summarize | Different order for actions which use Group By. Actions not supported with AMP: 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. |